List:Packagers« Previous MessageNext Message »
From:David Garamond Date:December 16 2002 2:05pm
Subject:Re: [packagers] /var/lib/mysql permission in recent mysql rpms
View as plain text  
Christian Hammers wrote:
>>i notice that recent mysql versions (including 3.23.54a that i just 
>>upgraded to) set /var/lib/mysql ownership and permission to 
>>(mysql,mysql,700). i used to remember that this is not so in older versions.
>>
>>the 700 permission mode causes problem in multiuser settings, where 
>>people connect from as unix users other than 'mysql' since they cannot 
>>open /var/lib/mysql/mysql.sock. i suggest changing it [back?] to 711?
> 
> Better stick with FHS, /var/lib/mysql is just for the databases,
> /var/run/mysqld/ for the .pid and the .sock and /var/log/mysql/ for 
> the log files (owned 0700 for security reasons).

yes, that's certainly better. but the current mysql rpm doesn't seem to 
put the .pid and .sock files there yet. mysqld still puts them in 
/var/lib/mysql/, yet /var/lib/mysql is set to 700.

-- 
dave

Thread
/var/lib/mysql permission in recent mysql rpmsDavid Garamond15 Dec
  • Re: [packagers] /var/lib/mysql permission in recent mysql rpmsChristian Hammers16 Dec
    • Re: [packagers] /var/lib/mysql permission in recent mysql rpmsDmitry V. Levin16 Dec
      • Re: [packagers] /var/lib/mysql permission in recent mysql rpmsChristian Hammers16 Dec
        • Re: [packagers] syslog (was: /var/lib/mysql permission in recentmysql rpms)Lenz Grimmer16 Dec
  • Re: [packagers] /var/lib/mysql permission in recent mysql rpmsDavid Garamond16 Dec