cant restart mysql

Joined
Sep 24, 2008
Messages
8
Reaction score
0
Points
1
Hi I am trying to start mysql on my server and its not starting gives me the following error message

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/private/var/mysql/mysql.sock' (38)

I have checked etc/my.cnf and it has

socket = /private/var/mysql/mysql.sock

i have checked php.ini.default and php.ini and they have

mysql.default_socket = /private/var/mysql/mysql.sock

I type locate mysql.sock
and it gives

/private/var/mysql/mysql.sock

any ideas what on earth is going on here?
i don't understand what is going on
 
Joined
Mar 17, 2008
Messages
6,879
Reaction score
191
Points
63
Location
Tucson, AZ
Your Mac's Specs
Way... way too many specs to list.
what happens when you issue..

mysql_config --socket

?
 
Joined
Mar 17, 2008
Messages
6,879
Reaction score
191
Points
63
Location
Tucson, AZ
Your Mac's Specs
Way... way too many specs to list.
Try changing the my.cnf to point to that as your socket
 
OP
T
Joined
Sep 24, 2008
Messages
8
Reaction score
0
Points
1
I tried that it just gives

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
 
OP
T
Joined
Sep 24, 2008
Messages
8
Reaction score
0
Points
1
I solved it the disk was full lol i had to remove a 29GB log file and reboot the server and hey presto mysql restarted. The lesson to be learnt is before you start playing around with config files check your hard disk space.
 
Joined
Mar 17, 2008
Messages
6,879
Reaction score
191
Points
63
Location
Tucson, AZ
Your Mac's Specs
Way... way too many specs to list.
:D :D yea, I've done that more than once.. a df would have saved me some time in the past :D
 
Joined
Oct 13, 2009
Messages
1
Reaction score
0
Points
1
MySQL not starting

Can someone tell me which mysql files I can remove in order to start mysql. I removed the two log files but I still can't restart mysql.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top