couldn't connect to mysql thru socket-help me

annumol · December 28th, 2007, 05:01 AM

I installed mysql 5.0.9 in fedora5.after installing when i gave command
mysqladmin version

an error getting like these.please help me

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

ciderpunx · May 13th, 2008, 08:58 AM

Go to the command line and type:

Code:

ps ax | grep mysql

If mysql is running you should get summit like:

Code:

 ps ax | grep mysql
 2667 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe
 2704 ?        Sl    92:29 /usr/sbin/mysqld --basedir=/usr --datadir=/var/mysql --user=uname --pid-file=/var/lib/mysqld/mysqld.pid --skip-external-locking --port=6969 --socket=/var/lib/mysqld/mysqld.sock

Check the bit that says socket= is pointing to /var/lib/mysql/mysql.sock

Cheers,
Charlie

--
Charlie Harvey's website - linux, perl, java, anarchism and punk rock: http://charlieharvey.org.uk