Hello,

/etc/init.d/mysql restart
Shutting down MySQL.. [ OK ]
Starting MySQL. [ OK ]

mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/data/var/lib/mysql/mysql.sock' (2)

mysql -u root -p --protocol tcp
Enter password:

mysql>

Could you please help me why mysql -u root -p is not allowing me to get inside the mysql prompt. But mysql -u root -p --protocol tcp is allowing me the access.

getenforce
Disabled

Kind regards,
Jojan Paul

check that /data/var/lib/mysql folder exists and that user mysql has ownership, if necessary shut down mysql, remove the mysql.sock file manually and try restarting mysql

There should be a line under section [mysqld] in your my.cnf file and it should be commented or not there, it is
If you uncomment the line or if it is not there so you put it in your my.cnf under the section [mysqld] then you restart the mysql, even you will not be able to connect to mysql using
Not listening on port TCP/IP can be a security enhancement, if all processes that need to connect to mysqld run on the same host.All interaction with mysqld must be made via Unix sockets or named pipes.

To start the mysql prompt using regular command, follow the solution of TenTenths.

Hi,

After adding below line in my.cnf the issue has been resolved.

[mysqld]
socket = /data/var/lib/mysql/mysql.sock

Kind regards,
Jojan Paul