Forum Moderators: coopster
I'm setting up PHP (5.0.4) and MySQL (Standard 4.0.25) on my Mac (OS X 10.3.2) so that I can build some pages in Dreamweaver. I have PHP installed properly... or so it seems by viewing the [127.0.0.1...] I created. My trouble seems to be with MySQL. I followed Marc Liyange's helpful tutorial and all seemed to go well until I tried to start up MySQL.
I enter:
sudo ./bin/mysqld_safe &
And get: I tried testing it by entering: And I get: Marc's tutorial suggests checking the .err files, but I (A) don't know enough unix to do that and (B) wouldn't know what to look for if I figured it out. Can anyone please help me out? I'm guessing this is a common issue as I saw some other post about 2002 errors. Thanks a lot! - Geoff [1][edited by: coopster at 6:49 pm (utc) on July 6, 2005]
2740
127:/usr/local/mysql geoff$ Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/127.0.0.1.pid
050706 13:52:40 mysqld ended
/usr/local/mysql/bin/mysql test
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[1]+ Done sudo ./bin/mysqld_safe
[edit reason] removed url per TOS [webmasterworld.com] [/edit]
STOPPING server from pid file /usr/local/mysql/data/127.0.0.1.pid
So there was a problem and the server stopped. No need to do anymore tests - this tells you it isn't running. I don't know whether there will be anything useful in the error logs or not.
/usr/local/mysql/data/
should hold your log files. In order to avoid repetitive and extraneoous info, you should be able to delete the ones names *.err or the like. Then try again to start mysql. You should generate new error files. Look inside and see what you can find and, if not obvious, post the results here (but please, only from the last attempt, not an entire log file!) Log messages all have date and time and so you only want the most recent set of messages.
