So I checked /usr/local/etc/rc.d/mysql-server and it said to add the following:
Code:
# Add the following line to /etc/rc.conf to enable mysql:
# mysql_enable (bool): Set to "NO" by default.
# Set it to "YES" to enable MySQL.
# mysql_limits (bool): Set to "NO" by default.
# Set it to yes to run `limits -e -U mysql`
# just before mysql starts.
# mysql_dbdir (str): Default to "/var/db/mysql"
# Base database directory.
# mysql_args (str): Custom additional arguments to be passed
# to mysqld_safe (default empty).
So in /etc/rc.conf, I added the following:
Code:
mysql_enable="YES"
mysql_limits="NO"
mysql_dbdir="/var/db/mysql"
mysql_args=""
Then I tried to start mysql with "sudo /usr/local/etc/rc.d/mysql-server start"
All I saw was "Starting mysql.", then nothing happened. I tried to query the server with "mysqladmin ping" and the response was
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
I'm not sure what to do next. Any suggestions would be much appreciated - is there a way to get verbose output from "mysql-server start"?