[chroder@EIN chroder]$ /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/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!
I've just installed mySQL on my RedHat9 system and now when I try to start it it gives me that error. When I installed it yesterday and ran mysqladmin, it worked fine, but now it won't. Any ideas?
I start it up by going ./bin/safe_mysql & (from the mysql directory) and it always hangs, outputting nothing so I end up closing the terminal window. If I try to start it again it says there is already a process, if I test it it gives errors. So I really don't know what to do.
(Assuming that was a typo about the directory structure)
If you there's *nothing* in "/usr/local/mysql/data", then you haven't completed the installtion of MySQL. If you think you completed installation of MySQL, you should *atleast* have the following directory - "/usr/local/mysql/data/mysql". Do you have it?
AFAIK, the mysql.sock file exists *only* as long as mysqld is running. So DON'T look for it when when MySQL IS NOT running. *If* you know mysqld is running and *yet* there's no mysql.sock then its a simple issue of permissions. Check if mysql user has permission to write to /tmp & check mysql.ini file to ensure mysql.sock is enabled and also the path where's its being written.
Last but not the least, please spend some more time with the MySQL manual. The online version (w/ user comments) is excellent.