Percona server not starting in jail after upgrading FreeBSD host from 9.2 to 9.3
📅 Dec 23, 2014
⌛ 1 minute
How to fix Percona server not starting in a jail after upgrading the FreeBSD host from 9.2 to 9.3
service mysql-server start
returned, butservice mysql-server status
showed 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
.