mysql error 2002

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

mysql error 2002

Postby 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!

User avatar
remoulder
Level 17
Level 17
Posts: 7653
Joined: Fri May 09, 2008 1:14 pm
Contact:

Re: mysql error 2002

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

Re: mysql error 2002

Postby 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.

-DataMan
Linux'd since 2005 Linux ID 422356 Ubuntu ID 15015


Return to “Software & Applications”

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot], Muckelfar, Yahoo [Bot] and 11 guests