Missing /var/lib/mysql/mysql.sock file

Question

I'm trying to access mysql and when I run the mysql command, I get the following.

[root@ip-10-229-65-166 tpdatabase-1.8.0.28356]# mysql

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

Doing this returns nothing

[root@ip-10-229-65-166 mysqld]# find -name mysql*

[root@ip-10-229-65-166 mysqld]# /etc/init.d/mysql stop -bash: /etc/init.d/mysql: No such file or directory

[root@ip-10-229-65-173 tpdatabase-1.8.0.28356]# mysql_config |grep -- --socket

--socket [/var/lib/mysql/mysql.sock]

Maybe a permissions problem?

I do have mysql installed using yum install mysql

I'm running CentOS 5.4 on a Amazon EC2 Cloud Instance

Answer 1

You need to install the server package:

sudo yum install mysql-server 

After installation, you have to start the service:

sudo service mysqld start 

Answer 2

rm -rvf /var/lib/mysql/ib_logfile* touch /var/lib/mysql/mysql.sock touch /var/lib/mysql/mysql.pid chown -R mysql:mysql /var/lib/mysql systemctl restart mysql 

try this and check the permission of both /var/lib/mysql/mysql.sock and /tmp