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.
6 messages in com.mysql.lists.packagersRe: [packagers] /var/lib/mysql permis...