where is mysql.sock located?

frustphil

frustphil

I have this error...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Click to expand...
I guess this because mysql.sock is not located in /tmp/...
Thanks =)
 
First of all, have you started MySQL? If it's already up and running, check /usr/local/etc/my.cnf to see where the socket is located. By default, it is /tmp/mysql.sock.
 
dennylin93 said:
First of all, have you started MySQL?
Click to expand...
Yup I've started it but if I issue these commmands I get...
/usr/local/etc/rc.d/mysql-server status
Nothing, just a blank line

/usr/local/etc/rc.d/mysql-server rcvar
# mysql
mysql_enable=NO
Click to expand...
Is there something I missed?

dennylin93 said:
If it's already up and running, check /usr/local/etc/my.cnf to see where the socket is located. By default, it is /tmp/mysql.sock.
Click to expand...

The file is empty...:(
 
Are you serious? It's sort of jumping off the page there.

Code: 
mysql_enable=NO

How about changing that to "YES" and starting MySQL with [cmd=]/usr/local/etc/rc.d/mysql-server start[/cmd]?
 
I found out that mysql is not running that's why mysql.sock is nowhere to be found. /usr/local/etc/rc.d/mysql-server start does not give affirmation that mysql is running. Also, looks like my problem is similar to this but the solutions there didn't work for me... Any help would be appreciated...
 
Weird, out of curiosity I deinstalled mysql50-server and installed mysql60-server and mysql is now running. I read somewhere that mysql60 is an alpha version, can anyone confirm this pls...
 
You must log in or register to reply here.
Back
Top