The binary installation mysql reports the following error

[[email protected] sdb1]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

It is found that /tmp/mysql.sock does not exist. The reason for this is generally due to inconsistent configuration files. If mysqld is started by mistake, mysqld_safe will clear mysql.sock once.

Solution

First check whether the current process has a surviving mysql, kill it, and then restart the database

$ ps -ef | grep mysql
$ kill -9 xxxx
$ /etc/init.d/mysqld start

If it still cannot be resolved, check whether the configuration file is correct

$ cat /etc/my.cnf
[mysqld]
user=mysql
basedir=/mnt/sdb1/mysql
datadir=/mnt/sdb1/mysql_data
socket=/tmp/mysql.sock
server_id=6
port=3306
[mysql]
socket=/tmp/mysql.sock

Use the command to find the mysql.sock file

$ find / -name mysql.sock

If not found, re-execute mysql_install_db to rebuild the authorization table

$ mysql/bin/mysql_install_db

Then execute the following command, the mysql.sock file will be there

$ mysql/bin/mysqld_safe &

$ find / -name mysql.sock
/tmp/mysql.sock

Read More:

• ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
• MySql Warning: The server quit without updating PID file error
• How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
• How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
• Docker mysql8 modify password
• After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
• MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
• ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
• [Solved] MySQL Error: Client does not support authentication protocol requested by server
• mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
• MySQL installation error: error while loading shared libraries: libaio.so .1: cannot open shared object file: No such
• Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
• Failed to load file or assembly MySql.Web Solution
• Mysql 8.0.13 Enabling remote access (ERROR 1064 (42000): You have an error in your SQL syntax; check the manual th)
• Mybatis Error: The server time zone value ‘����1532a0’ is unrecognized
• (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
• MySQL Error: Error writing file ‘/tmp/MY4WYVlC‘ (Errcode: 28 – No space left on device)
• Error 1418 (HY000): this function has none of deterministic, no SQL
• How to Solve Embulk Error: OutputPlugin’bigquery’ is not found
• How to Fix MySQL error 1005: can’t create table (errno: 150)