mysql error 2002

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
Level 1
Level 1
Posts: 2
Joined: Sat Nov 24, 2012 12:09 pm

mysql error 2002

Post by mattcuk » Sat Nov 24, 2012 5:33 pm

I'm trying to get mysql working and it's throwing back problems that I can't seem to find the answer to.

I've installed the mysql-server and left the default settings in the 'my.cnf' file.
**(I've changed the local host to my own ip address and no change)

When I pass 'mysql -u root' if get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
**(I've changed the files to /tmp/mysql/mysql.sock and I get the same message)

I've checked if mysql is running with:

'ps -ef | grep mysql'
mysql 4347 1 0 21:22 ? 00:00:00 /usr/sbin/mysqld
matt 4635 2921 0 21:24 pts/0 00:00:00 grep --colour=auto mysql

'service mysql status'
mysql start/running, process 4347

...So I think that it is.

Thanks in advance!

Level 17
Level 17
Posts: 7636
Joined: Fri May 09, 2008 1:14 pm

Re: mysql error 2002

Post by remoulder » Sat Nov 24, 2012 7:28 pm

Mint version and desktop please, see how to get help
[Edit] your original post and add [SOLVED] once your question is resolved.

“The people are my God” stressing the factor determining man’s destiny lies within man not in anything outside man, and thereby defining man as the dominator and remoulder of the world.

User avatar
Level 6
Level 6
Posts: 1234
Joined: Thu Dec 04, 2008 6:47 am
Location: Carmel, Midwest USA at /var/www

Re: mysql error 2002

Post by DataMan » Sun Nov 25, 2012 7:26 am

Just a wag, but I suspect you have a conflict stemming from the rename of the server. If you're willing to explore this posssibility, do a complete uninstall of MySQL server and client and re-install with the default localhost server name.

Linux'd since 2005 Linux ID 422356 Ubuntu ID 15015

Post Reply

Return to “Software & Applications”