mysql error 2002

Questions about applications and software
Forum rules
Before you post read how to get help. Topics in this forum are automatically closed 6 months after creation.
Locked
mattcuk

mysql error 2002

Post by mattcuk »

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!
Last edited by LockBot on Wed Dec 28, 2022 7:16 am, edited 1 time in total.
Reason: Topic automatically closed 6 months after creation. New replies are no longer allowed.
remoulder
Level 17
Level 17
Posts: 7621
Joined: Fri May 09, 2008 1:14 pm

Re: mysql error 2002

Post by remoulder »

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

Re: mysql error 2002

Post by DataMan »

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
Locked

Return to “Software & Applications”