Question
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Posted July 23, 2017
- WordPressMySQLLinux CommandsCentOS
Hi, I currenty have a LAMP, running on Centos, everything was fine, but my MYSQL is not working.
When i try to connect via
mysql -u root -p
I get the error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)
Note: This error has been occur, when i will install WordPress theme on my Site, after this, i will click on the Import Demo Button to import the FrontPage, then error occur.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Restart MySQL
service mysqld start
if using MariaDB use
sudo systemctl start mariadb
Dear, When i will enter this command on PuTTy, i get an error tail: cannot open ‘/var/log/mysql/error.log’ for reading: No such file or directory Note: I have 512 MB Ram Server with lot of Bandwidth Available. I Will Deploy Server and Start Installing WordPress, everything was fine, but when i will try to install theme, after this it shows an database error.
lsof -i:3306 kill the running process with kill -9 PID then restart the mysql service
This comment has been deleted
The error message means that mysql process has crashed for some reason please share your mysql error log by giving as the output of this command
tail -20 /var/log/mysql/error.log
My guess is that your droplet is running out of memory how much memory did you allocate for it?
Hope this helps.
This comment has been deleted