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

[Alf Stockton]

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

:-(

-- 
Regards,
Alf Stockton		www.stockton.co.za

"Elves and Dragons!" I says to him.  "Cabbages and potatoes are better
for you and me."
		-- J. R. R. Tolkien