/SQL/ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

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

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

sudo chown -R _mysql:mysql /usr/local/var/mysql

sudo mysql.server start

12

Source: stackoverflow.com

Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)

Try to start the MySQL server:
mysql.server start

6

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

> ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
> 
> service mysql start or service mysql start

4

Source: stackoverflow.com

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

systemctl stop mysql

sudo usermod -d /var/lib/mysql/ mysql

systemctl start mysql

2

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

$ mysql.server start

0

Source: medium.com

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

sudo chown -R _mysql:mysql /usr/local/var/mysql

sudo mysql.server start

0

Source: stackoverflow.com

Similar codes

2 votes178 views1 answer
Oracle percentage
SQL
0 vote181 views1 answer
How to check which table has data in mysql
SQL
0 vote160 views1 answer
Update top 100 sql
SQL
1 vote179 views1 answer
Sql server update column based on another table
SQL
0 vote177 views1 answer
Oracle sql number to varchar2
SQL
1 vote218 views1 answer
Sql oracle update multiple rows
SQL
22 votes218 views4 answers
Date format mysql
SQL
0 vote165 views1 answer
Mysql in clausule string array
SQL
0 vote184 views1 answer
Mysql get nth highest
SQL
0 vote168 views1 answer
Update table sql multiple set
SQL

Share