image
image

|


Go Back   macosx.com > Mac Help Forums > Mac OS X System & Mac Software

Reply
 
Thread Tools
  #1  
Old April 9th, 2001, 06:20 AM
kzo kzo is offline
Registered User
 
Join Date: Apr 2001
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
kzo is on a distinguished road
Unhappy

The first day I installed this it was running great with apache and php. But now it doesn't run.
When I type >mysql in the terminal it says:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I did a search using find / -name "mysql.sock" and it doesn't exist. Nothing came up.

I don't know what to do, please help.
thanks

kzo
Reply With Quote
  #2  
Old April 9th, 2001, 01:01 PM
Registered User
 
Join Date: Apr 2001
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
fee-5 is on a distinguished road
is the server running?

Make sure you actually have mysql running.

From the command line:

% ps aux | grep 'mysql'

This will show you all the mysql processes that are currently running.

If the mysql server isn't running:

% safe_mysqld

This will seem to "freeze" the terminal, but that's normal. It means that you've started mysql under that login.

Hope this helps.

--
fee-5

PS: Unless you have mysql set up to start every time the box boots, you'll have to restart it manually with "safe_mysqld" every time.
Reply With Quote
  #3  
Old April 9th, 2001, 04:26 PM
kzo kzo is offline
Registered User
 
Join Date: Apr 2001
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
kzo is on a distinguished road
Talking

wow that was simple enough.

thank you
Reply With Quote
  #4  
Old April 9th, 2001, 04:39 PM
Senior Member
 
Join Date: Sep 2000
Location: Salt Lake City
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Tyler is on a distinguished road

If you decide not to have mysql start up automatically when you reboot, a better way to start it is....

% safe_mysqld &

Which will start mysqld as a background process -- leaving your terminal window available for other commands.


Tyler


Reply With Quote
  #5  
Old April 10th, 2001, 05:48 AM
rharder's Avatar
Do not read this sign.
 
Join Date: Mar 2001
Location: Virginia, USA
Posts: 1,186
Thanks: 0
Thanked 0 Times in 0 Posts
rharder is on a distinguished road
Would he have to type "nohup safe_mysqld &" to make sure the process doesn't die when the Terminal window gets closed?

-Rob
Reply With Quote
  #6  
Old April 17th, 2001, 03:04 AM
Registered User
 
Join Date: Apr 2001
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Snowman is on a distinguished road
yeah that too
Reply With Quote
  #7  
Old October 30th, 2001, 01:52 AM
Registered User
 
Join Date: Sep 2001
Location: San Jose, ca
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
catnip is on a distinguished road
Ok, but I'm getting this same error message, and I do get something back from :

ps aux | grep 'mysql'

and the result is:
steve 1184 0.0 0.1 5768 104 std RV 0:00.01 grep mysql

but, when I try to access my DB, I get:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

there was a lot of great information about starting the server if it isn't running, but what can I do in my situation? every time I reboot this happens, and I know there's gotta be a way to fix this, isn't there??

thanks
-Steve
Reply With Quote
  #8  
Old March 25th, 2002, 03:59 PM
cavneb's Avatar
Programmer / Gamer
 
Join Date: Aug 2001
Location: UK
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
cavneb is on a distinguished road
i am having the same problem

i am having the exact same problem...
Reply With Quote
Reply

Thread Tools

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 Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Are there any MySQL installs that actually work? David Rodger Mac OS X System & Mac Software 15 March 30th, 2003 01:56 AM
MySQL install problems svenrg Unix & X11 2 November 21st, 2002 10:08 PM
MySQL & StartupItems Problem turbine Unix & X11 2 September 27th, 2002 10:44 PM


All times are GMT -5. The time now is 03:59 AM.


Mac Support® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2000-2008 DigitalCrowd, Inc.