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

Dung Do Tien Apr 01 2021 312

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. The type initializer for 'gdip' threw an exception on linux ubuntu
  2. Error string or binary data would be truncated by update in mssql server
  3. FE .Net Core Error: To change the IDENTITY property of a column, the column needs to be dropped and recreated.
  4. Asp.net Core: Duplicate 'global::System.Runtime.Versioning.TargetFrameworkAttribute' atribute
  5. Nodejs Error: "NODE_ENV" is not recognized as an internal or external command
  6. Angular : If ngModel is used within a form tag, either the name attribute must be set
  7. Angular: No value accessor for form control with unspecified name attribute
  8. Php and Mysql error: could not find driver when migrate version
  9. How to create and write data into a txt text file in Nodejs?
  10. Can't bind to 'ngModel' since it isn't a known property of 'input' in Angular
  11. Could not find a part of the path 'roslyn/csc.exe' in Asp.Net Mvc
  12. TypeError: unsupported operand type(s) for %: 'NoneType' and 'str' in Python
  13. PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
  14. Denied: access forbidden in gitlab cicd with .net 6
  15. Unable to start Logstash service on Linux Ubuntu 20.04
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