View Single Post
  #3   (View Single Post)  
Old 9th December 2008
Mantazz Mantazz is offline
Shell Scout
 
Join Date: Oct 2008
Posts: 90
Default Still confused...

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"?
Reply With Quote