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.