
# mysql
ERROR 2002 (HY000):
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
If you try to start mysql server and you get the above error 2002 (HY000), the most common reason is that the mysql service is not running, in order to fix that you need to start the mysql server,
Solution:# sudo service mysql start
* Starting MySQL database server mysqld [ OK ]
Now try to get into mysql prompt and you should be through!
root@b2391b608026:/# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.28-0ubuntu0.20.04.3 (Ubuntu)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
We can also check if the mysql service is running or not using the service status command,
sudo service mysql status
* /usr/bin/mysqladmin Ver 8.0.28-0ubuntu0.20.04.3 for Linux on aarch64 ((Ubuntu))
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 8.0.28-0ubuntu0.20.04.3
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 7 min 22 sec
Threads: 2 Questions: 10 Slow queries: 0 Opens: 117
Flush tables: 3 Open tables: 36 Queries per second avg: 0.022
If the device is not running you will see MySQL is stopped.
# sudo service mysql status
* MySQL is stopped.
More Posts related to MySQL,
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL: Error Code: 1175 You are using safe update mode
- Connection Failed: 1130 PHP MySQL Error
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Display List of Databases in mysql Command Line
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL Query for Schema/Structure of a Table
- How to find AUTO_INCREMENT Fields value in MySQL table
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- Identify MySQL version in MySQL Command Line Prompt
- How to clear MySQL Console Screen
More Posts:
- Save cURL Command Output to a external file - cURL
- How to use Content Assist in Eclipse IDE - Eclipse
- How to recover unsaved notepad file Windows 10 - NotepadPlusPlus
- Eclipse version 32-bit or 64-bit check on macOS - Eclipse
- [Android Studio] failed to find Build Tools revision 23.0.0 rc1 - Android-Studio
- How to customize SharePoint Modern list form using JSON formatting - SharePoint
- Comparator with Lambda Examples - Java
- Submit html form on dropdown menu value selection or change using javascript - JavaScript