Why would this: ./mysqladmin versio

[frozenpeas]

Why would this: ./mysqladmin version

give this error:

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

 

[sleipnir214]

Check to make sure that the mysql daemon is running.

 

[frozenpeas]

I did, then I checked the error log. I got this (scout is my hostname):

020609 14:56:01  mysqld started
020609 14:56:02  /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/scout.pid' (Errcode: 13)
020609 14:56:02  /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
020609 14:56:02  /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/scout.pid' (Errcode: 2)
020609 14:56:02  mysqld ended

Any idea where I should go from here? Thanks.

 

[sleipnir214]

Did you look at the post-installation testing page of the mysql online manual?

http://www.mysql.com/doc/P/o/Post-installation.html

 

[frozenpeas]

I'm looking at it. I've done the mysql_install_db stuff before. Here is what I am getting now (when trying to set my root password):

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

Is MySQL always this hard to get working or do I just have good luck?

Thanks.

 

[sleipnir214]

You're lucky, but don't feel special. This problem crops up from time-to-time.

Try putting mysql.sock somewhere besides /tmp. This is set in your my.cnf file. You may have to create a directory owned by the user mysql runs as, and put it there.

 

[KarveR]

check the permissions on this '/tmp/mysql.sock'
/tmp should be rwxrwxrwx (chmod -r 777) [possibly you will need -R instead) recursice change of permissions on /tmp will allow you permission to login to mysql. ***************************************
Party on, dudes!

 

[sleipnir214]

If you are going to keep mysql.sock in /tmp, make sure that your machine does not have some kind of cronjob that cleans up old files in the /tmp directory. Use of mysql.sock to communicate with MySQL does not update the timedate stamp on the file, and your cleaning app might just delete it for you.