Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Dung Do Tien Apr 01 2021 286

Hello,

I created a project with PHP7 and Apache server. I also install MySQL database in my VPS (Linux Ubuntu 18.0.4)

But when I publish this project into VPS and run mysql -u root -p command I got an error:  Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

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

Please help if you knew any reason.

Have 2 answer(s) found.
  • จ

    จักรพงษ์ รักษาศรี Apr 01 2021

    Maybe the MySql service is not active.  To check the status you can use the command below:

    sudo service mysql status

    If your MySql is not active, you can active it by command below:

    sudo service mysql start

    To restart service:

    sudo service mysql restart

    To stop service:

    sudo service mysql stop

    I hope it useful for you.

  • M

    MSIIIXI Apr 01 2021

    I got the same error, you have to reload apparmor setting. You can run commands as below:

    sudo service mysql stop 
sudo /etc/init.d/apparmor reload
sudo service mysql start

    Run line by line command, and finally run mysql -u root -p command to access to MySql CLI. If you can access it, your issue is resolved.

Related Q&A May You Like

  1. How check if the variable is a number or not in javascript?
  2. How to center text of <p> tag html using CSS?
  3. How to get client ip address in asp.net core using c#?
  4. [Resolved] String cannot be of zero length. Parameter name: oldValue
  5. Error: Unable to resolve module "react-native-gesture-handler"
  6. Operator '!' cannot be applied to operand of type '<null>' in Asp.Net Core
  7. Php and Mysql error: could not find driver when migrate version
  8. Uncaught TypeError: Cannot read property 'createElement' of undefined in ReactJs
  9. How to random number generator 1-100 in Python?
  10. ValueError: Input contains NaN, infinity or a value too large for dtype('float64') in Python
  11. TypeError: 'list' object cannot be interpreted as an integer in Python
  12. PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
  13. ImportError: No module named MySQLdb in Python Django
  14. Exception throw referencerrror: fs is not defined in NodeJs
  15. What is best way to convert datetime to date in Sql Server?
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close