mysql error 2002

Questions about applications and software
Forum rules
Before you post please read how to get help

mysql error 2002

Postby mattcuk on 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 1
Level 1
Posts: 2
Joined: Sat Nov 24, 2012 12:09 pm

Linux Mint is funded by ads and donations.

Re: mysql error 2002

Postby remoulder on 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 17
Level 17
Posts: 7662
Joined: Fri May 09, 2008 1:14 pm

Re: mysql error 2002

Postby DataMan on 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
User avatar
Level 6
Level 6
Posts: 1234
Joined: Thu Dec 04, 2008 6:47 am
Location: Carmel, Midwest USA at /var/www

Return to Software & Applications

Who is online

Users browsing this forum: Fred Barclay and 13 guests