I am running Redhat 6.2 and installed the following MySQL from this document. All was well until I tried to start the daemon. It spitted out an error:
Error 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
Any ideas?? Prior to installing the tarred MySQL I had the RPM MySQL from Red Hat running. I thought it could be file permissions because Red Hats MySQL creates a user mysql and runs stuff under that.
Anybody know what's wrong??
July 11th, 2000, 08:57 AM
as they say RTFM!
check out the documentation, it has a part on "problems starting mysqld"
things it mentions:
- check you don't already have mysql running. that rpm might have left a start up script lying around or there may be an entry in rc.local which has beat you to it
- check the error log. it's in the data directory, with name 'hostname.err' where hostname is the name of your box
August 26th, 2000, 11:01 AM
I had that exact same problem.
How are you trying to start the dameon? You MUST go to the directory that mysql is installed in, and run "./safe_mysqld &" it then creates mysql.sock.
its easier to use the RPM version of MySQL, the setup is alot easier, and it installs everything so you dont have to worry about making the binaries.