Computing.Net > Forums > Web Development > don't understand this MySQL error

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

don't understand this MySQL error

Reply to Message Icon

Name: dmack
Date: March 8, 2005 at 19:40:55 Pacific
OS: Mac OS X 10.2.8
CPU/Ram: Dual G4/512MB
Comment:

Alright, I'm really bummin' here.

I found a site that seemed like it was going to be the answer to my MySQL configuration prayers http://www.quicomm.com/apm_mysql.htm. But something has gone wrong and I don't have the MySQL experience to fix it. I'm getting the following message after entering the "mysqladmin version" command in the Unix shell:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Anyone out there ever come across this and have any idea what it means or how to correct it?



Sponsored Link
Ads by Google

Response Number 1
Name: anonproxy
Date: March 9, 2005 at 22:07:42 Pacific
Reply:

I'm going to assume the socket file exists and the server is running (i.e. the obvious).

- Use an explicit path for the socket:
mysqladmin --protocol=socket --socket=[$filepath] version

- You may not have read/writes to the socket file (or directory). The above instructions you reference should have resolved this though (but I'm not running mysql on osx, so..)

Try specifying the hostname explicitly in the command:

mysqladmin -h [hostname] --port=3306 version

You can use TCP/IP ports instead of sockets. To do this, use a hostname rather than a socket. Localhost automatically uses sockets, by the way.


0
Reply to Message Icon

Related Posts

See More


PHP -Processing server co... PHP JPEG file download on...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Web Development Forum Home


Sponsored links

Ads by Google


Results for: don't understand this MySQL error

javax.mail problem with cc option www.computing.net/answers/webdevel/javaxmail-problem-with-cc-option/2684.html

Compare 2 Lists of Words www.computing.net/answers/webdevel/compare-2-lists-of-words-/2500.html

How to use PHP Nuke? www.computing.net/answers/webdevel/how-to-use-php-nuke/2094.html