Percona server not starting in jail after upgrading FreeBSD host from 9.2 to 9.3
-
service mysql-server startreturned, butservice mysql-server statusshowed that it was not started successfully. -
The log file /var/db/mysql/mysql-error.log warned that writing a file to /var/db/mysql failed.
-
Checking the permissions on /var/db/mysql showed that existing files in the folder were owned by user mysql and group mysql, but the directory itself was owned by user root and group wheel.
-
After granting user mysql and group mysql ownership of the folder (
chown mysql:mysql /var/db/mysql) the server could be started successfully withservice mysql-server start.