mysql error 2002

Questions about applications and software
Forum rules
Before you post please read this

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!
mattcuk
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
remoulder
Level 17
Level 17
 
Posts: 7667
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.

-DataMan
Linux'd since 2005 Linux ID 422356 Ubuntu ID 15015
User avatar
DataMan
Level 6
Level 6
 
Posts: 1202
Joined: Thu Dec 04, 2008 6:47 am
Location: Carmel, Indiana USA at /var/www


Return to Software & Applications

Who is online

Users browsing this forum: philliegp and 31 guests