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 startERROR 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 startERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
# Remove mysql
sudo apt-get remove --purge mysql\*
#update repositories
sudo apt update
# Reinstall it
sudo apt install mysql-server mysql-client
# Test if it runs
sudo mysql
# You can install also thes pachages. Optionnaly
sudo apt install php
#mesabo youbeyouERROR 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 startERROR 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 -perror 2002 (hy000): can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2)
mysql -h 127.0.0.1 -P 3306 -u root -p <database>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
For mac:
The mysql server is not running.
brew services mysql startCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
