2

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

When I check the directory there is no mysql folder. How should I solve this problem? It's worth mentioning when I do service mysql start (or with mysqld) it errors unrecognized service.

I should mention that I have changed the path in my.cnf but nothing happens. The problem is that no *.sock file exists at all.

Update:

Results of checking mysql process with mysqladmin -u root -p status returns:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Also when I directly want to run /etc/init.d/mysqld it errors that it cannot resolve the ip (localhost.localdomain).

Second Update:

I have run the command [root@localhost /]# rpm -qa | grep mysql

and it returns:

mysql-libs-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.i686
mysql-5.1.73-3.el6_5.x86_64
mysql-server-5.1.73-3.el6_5.i686
4
  • 2
    Did you start the mysql process? Is it running?
    – Sreeraj
    Commented Jan 4, 2015 at 9:22
  • Have you tried changing path from "/var/run/..." to /var/lib/..." in my.cnf? Also, run ps aux | grep mysql
    – kirill-a
    Commented Jan 4, 2015 at 10:20
  • Check if you have this line in /etc/hosts 127.0.0.1 localhost.localdomain
    – Boban P.
    Commented Mar 23, 2016 at 7:38
  • and give us a my.cnf
    – Boban P.
    Commented Mar 23, 2016 at 7:39

2 Answers 2

0

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with

socket=/var/lib/mysql/mysql.sock

you can check if mysql is running with the following command:

mysqladmin -u root -p status

try changing your permission to mysql folder. If you are working locally, you can try:

sudo chmod -R 755 /var/lib/mysql/

source

2
  • please see the question is updated Commented Jan 4, 2015 at 10:19
  • And it's worth I'm root user. No need for chmod Commented Jan 4, 2015 at 10:20
0

Looks like you just installed MySQL client not the server. Use the command below to install the server yum install mysql-server

Also you can refer the link for more information:- MySQL

2
  • I have installed it. Look at my updated question. Thanks you Commented Jan 4, 2015 at 11:18
  • check the binding of MySQL using the command lsof -i:3306 may be it's not listening on localhost
    – Karthik
    Commented Jan 4, 2015 at 17:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .