I installed mariadb in a jail and was working but now it will not start. I don't care about the data, i'm learning.
what I did:
spin up new jail
pkg install mariadb104-server : no errors
service mysql-server start : installs in /var/db/mysql
service mysql-server status
mysql is not running
service mysql-server start
service mysql-server status
mysql is not running
mysql -u root -p
error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock'
obviously, it's not running
deets:
i've done
pkg remove mariadb104-server : no errors
pkg autoremove : no errors
rm -r /var/db/mysql
reinstalled mariadb
no my.cnf file to edit
"/var/.../database test.err" shows "...mysqld: too many arguments (first extra is 'test.pid')."
but there is no my.cnf file to fix
what I did:
spin up new jail
pkg install mariadb104-server : no errors
service mysql-server start : installs in /var/db/mysql
service mysql-server status
mysql is not running
service mysql-server start
service mysql-server status
mysql is not running
mysql -u root -p
error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock'
obviously, it's not running
deets:
i've done
pkg remove mariadb104-server : no errors
pkg autoremove : no errors
rm -r /var/db/mysql
reinstalled mariadb
no my.cnf file to edit
"/var/.../database test.err" shows "...mysqld: too many arguments (first extra is 'test.pid')."
but there is no my.cnf file to fix