New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Development and Darwin Discussion and questions about development for Mac OS X.

cant restart mysql


Post Reply New Thread Subscribe

 
Thread Tools
timgolding

 
Member Since: Sep 24, 2008
Posts: 8
timgolding is on a distinguished road

timgolding is offline
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
QUOTE Thanks
Dysfunction

 
Dysfunction's Avatar
 
Member Since: Mar 17, 2008
Location: Tucson, AZ
Posts: 6,638
Dysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant future
Mac Specs: 2008 and 2011 15" mbps, late 11 iMac, iPhone 4s, and too many ipods and other stuff

Dysfunction is offline
what happens when you issue..

mysql_config --socket

?

mike
This machine kills fascists
Got # ? phear the command line!
QUOTE Thanks
timgolding

 
Member Since: Sep 24, 2008
Posts: 8
timgolding is on a distinguished road

timgolding is offline
if i type mysql_config --socket i get

/var/mysql/mysql.sock
QUOTE Thanks
Dysfunction

 
Dysfunction's Avatar
 
Member Since: Mar 17, 2008
Location: Tucson, AZ
Posts: 6,638
Dysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant future
Mac Specs: 2008 and 2011 15" mbps, late 11 iMac, iPhone 4s, and too many ipods and other stuff

Dysfunction is offline
Try changing the my.cnf to point to that as your socket

mike
This machine kills fascists
Got # ? phear the command line!
QUOTE Thanks
timgolding

 
Member Since: Sep 24, 2008
Posts: 8
timgolding is on a distinguished road

timgolding is offline
I tried that it just gives

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
QUOTE Thanks
timgolding

 
Member Since: Sep 24, 2008
Posts: 8
timgolding is on a distinguished road

timgolding is offline
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.
QUOTE Thanks
Dysfunction

 
Dysfunction's Avatar
 
Member Since: Mar 17, 2008
Location: Tucson, AZ
Posts: 6,638
Dysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant futureDysfunction has a brilliant future
Mac Specs: 2008 and 2011 15" mbps, late 11 iMac, iPhone 4s, and too many ipods and other stuff

Dysfunction is offline
yea, I've done that more than once.. a df would have saved me some time in the past

mike
This machine kills fascists
Got # ? phear the command line!
QUOTE Thanks
joburke10

 
Member Since: Oct 13, 2009
Posts: 1
joburke10 is on a distinguished road

joburke10 is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« stringWithFormat or initWithFormat ? | Programming in C »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Brand New MacBook Pro will not Restart - Please Help! pforan Apple Notebooks 8 12-21-2008 12:22 PM
Compiling MySQL for Leopard Neko_D OS X - Operating System 0 05-26-2008 06:56 PM
MacGirl needs help! - Error msg @ boot, must restart but computer comp' won't restart MacGirl Apple Notebooks 17 12-10-2007 10:03 PM
Fresh install of MySQL denies access to root IceLatte Web Design and Hosting 0 06-24-2007 05:04 PM
stuck in restart loop Griffo OS X - Operating System 2 10-16-2006 11:47 AM

All times are GMT -4. The time now is 10:33 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?