I installed mysql-server in a jail (running FreeBSD 11.0-RELEASE) with:
When I try to start it:
The following is returned:
A google search tells me others have experienced this issue (https://forums.freebsd.org/threads/no-database-will-run-on-my-10-2.56564/; https://serverfault.com/questions/7...server-5-7-12-fails-to-start-on-freebsd-10-3; https://stackoverflow.com/questions/37103450/freebsd-mysql-error-after-installation). I've tried some suggestions with no luck.
Most suggest suggest something like:
then:
then:
Which gives me the same initial error:
pkg install mysql80-server-8.0.2_1
When I try to start it:
service mysql-server start
The following is returned:
WARNING: failed precmd routine for mysql
A google search tells me others have experienced this issue (https://forums.freebsd.org/threads/no-database-will-run-on-my-10-2.56564/; https://serverfault.com/questions/7...server-5-7-12-fails-to-start-on-freebsd-10-3; https://stackoverflow.com/questions/37103450/freebsd-mysql-error-after-installation). I've tried some suggestions with no luck.
Most suggest suggest something like:
rm -rf /var/db/mysql/*
then:
/usr/local/libexec/mysqld --initialize --user=mysql
then:
service mysql-server start
Which gives me the same initial error:
WARNING: failed precmd routine for mysql