Why do I get error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' on shell?

If you get this error message when trying to use mysql command line utility from shell:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

It means you need to access the mysql using -h 127.0.0.1 e.g.

mysql -h 127.0.0.1 -u yourdbuser -p yourdatabase

If you get this error message from a web script, please check with support for the status of the mysql server.

Was this answer helpful?

 Print this Article

Also Read

phpMyAdmin

phpMyAdmin is a third-party tool included with cPanel, used for maniuplating MySQL databases...

What is MySQL?

MySQL is an open source relational database management system. MySQL is noted mainly for its...

How can I backup and restore my MySQL databases?

There are two main ways to back up or restore a MySQL database on our servers: via SSH or the...

Can I import csv files using Load Data Infile?

This feature is not supported by cpanel but you can ask support to add File_priv to your db user...

How to create and use MySQL database

MySQL Databases Databases offer a method for managing large amounts of information easily...