Answers for "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'"

SQL
11

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
Posted by: Guest on May-12-2020
0

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

##	ERROR 2002 (HY000): 
##	Can't connect to local MySQL server through socket 

#### Follow below steps and you good to go... ####
sudo dpkg-reconfigure mysql-server-{version_number}
##version_number should be mysql version number installed
## Now try login in mysql shell
sudo mysql -u root -p
Posted by: Guest on August-18-2020
0

can't connect to local mysql server through socket

Solution #1: Check If MySQL Service is Runnning.
Solution #2: Connect with 127.0. 0.1.
Solution #3: Modify the my. cnf file.
Solution #4: Verify mysql. sock Location.
Solution #5: Change MySQL Folder Permission.
Solution #6: Multiple MySQL Instances.
Posted by: Guest on March-23-2020

Code answers related to "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'"

Code answers related to "SQL"

Browse Popular Code Answers by Language