It appears that mysqld is not listening on /tmp/mysql.sock.
Log into mysql and run show variables like 'socket';
This will tell you where mysqld is actually listening for socket
connections.
Then update your my.cnf files so they all have the same sock file
location as the
one that mysqld is listening on.
$B2&@E(B wrote:
>hi all, here is the suituation
>i've installed mysql4.1.14 under the /usr/local directory. the problem
>is, the server can work properly, however, mysqladmin doesn't. i
>posted it yesterday, and someone suggested me to issue the following
>command, however the same error 111 occured.
>
>#mysqladmin -uroot password mypwd
>#error: can't connect to local MySQL server through socket
>'/tmp/mysql.sock'(111)
>
>but, the server is *really* running.
>#ps -e | grep mysqld shows mysqld_safe and several other mysqld threads.
>
>i'm wodering if mysqladmin requires parsing some .rc files(if any) or
>interpreting some environment variables(if any) but they have wrong
>settings or values?
>
>any hits or help or advice would be most appreciated.
>
>
>
