Hello everybody,

The problem I’m having has been discussed many times over but I haven’t been able to locate a conclusive answer to resolve my issue..

The error message I get starting mysql t à error 2002: Can’t connect to local mysql server through socket ‘/tmp/mysql.sock’(2).

Before I installed mysql, I looked at several different installation methods and was able to successfully install mysql. The instructions I installed from: http://www.dmxzone.com/ShowDetail.asp?NewsId=1215.

-Redhat 9
-downloaded the source code and compiled and installed mysql v4.
-only thing I haven’t done is change the password but that’s another problem I’m having..
I looked in /tem/mysql.sock and nothing there to be found.. I’m new so I’m assuming this file gets created at Mysql startup.
did a search for mysql.sock and it’s no where to be found.
-mysql is installed under /wwwroot/mysql
tried the following commands to start the mysql server…/wwwroot/mysql/bin/mysql start( displays the above message). …/wwwroot/mysql/bin/mysqld_safe –user=mysql &(msg=command not found), /wwwroot/mysql/lib/mysql start still no go…alos tried mysql.server.

my.cnf –port is pointing to 3306

-my research, also pointed to this folder /var/lib/mysql/mysql.sock but mysql.sock isn’t there either..

3 days of reading and figuring out whats wrong with mysql hasn’t produced any results.
What am I missing other then my hair that I lost trying to figure this out…

Help
Robin

did you start the mysql deamon before looking for the sock file it has to be running to accept connections if not do /sbin/service mysql start (it could be mysqld) that should start it and then u can connect to it

Also type hostname at a prompt, if it is not localhost, then type hostname localhost....and then go and start the mySQL service.