[ubuntu-za] Can't connect to local MySQL server

[Louis van der Merwe]

2009/1/28 Alf Stockton <alf at stockton.co.za>:
> Neil Muller wrote:
>> On Wed, Jan 28, 2009 at 02:13:13PM +0200, Alf Stockton wrote:
>>> After stopping mysqld I removed the /var/lib/mysql/mysql.sock and restarted
>>> mysqld but still cannot log on as follows:-
>>> root at general:~# ps aux | grep mysql
>>> root     25321  0.0  0.0   3944   604 pts/3    S    13:59   0:00 /bin/sh
>>> /usr/bin/mysqld_safe
>>> mysql    25360  0.0  0.8  83296  9232 pts/3    Sl   13:59   0:00
>>> /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
>>> --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
>>> --socket=/var/run/mysqld/mysqld.sock
>>
>> So the mysql server is listening for connections via
>> /var/run/mysqld/mysqld.sock
>>
>>> root     25362  0.0  0.0   5068   812 pts/3    S    13:59   0:00 logger -p
>>> daemon.err -t mysqld_safe -i -t mysqld
>>> root     25442  0.0  0.0   5164   832 pts/3    R+   14:03   0:00 grep mysql
>>> root at general:~# mysql -u root
>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>>> '/var/lib/mysql/mysql.sock' (2)
>>
>> yet the client is still using /var/lib/mysql/mysql.sock - looks a bit
>> dubious, no?
>>
>> I'd first try using the --socket option to mysql to try the one the
>> server's listening on, to see that things are indeed working, and then,
>> since that really should work, try and track down why your client's
>> using the wrong socket - you probably have socket speicified incorrectly
>> either in ~.my.cnf or /etc/mysql/my.cnf
>>
> Thank you Neil. You were correct and as soon as I set the following links all
> worked well.
>
> sudo ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock
> and
> sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
>
> :-(
>


Hi again,

As someone suggested earlier, edit your /etc/mysql/my.cnf file

under the [client] section set the socket parameter

your symbolic link obviously worked, but it may give you problems down the line

cheers

Louis