Can‘t find mysqld.sock: Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.s

mysql使用遇到异常

Can't find mysqld.sock: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 “No such file or directory”)

卸载mysql

sudo service mysql stop
sudo apt-get --purge remove "mysql*"
sudo rm -rf /etc/mysql/ 

or

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean

$ sudo dpkg -l | grep -i mysql  # check

参考：https://stackoverflow.com/questions/45267036/cant-find-mysqld-sock-cant-connect-to-local-mysql-server-through-socket-var

安装mysql

sudo apt-get update
sudo apt-get upgrade  

sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev

参考：https://www.cnblogs.com/haxianhe/p/9271088.html

配置mysql

https://blog.csdn.net/qq_37598011/article/details/93489404

mysql root用户密码初始化异常

ERROR1698(28000):Access denied for user root@localhost

解决方案：https://www.cnblogs.com/cpl9412290130/p/9583868.html

以上都不如直接docker部署

docker pull mysql:5.7
docker run -p 3306:3306 --name mysql_devbox -v /home/xxx/tool/mysql/data:/var/lib/mysql -v /etc/localtime:/etc/localtime -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7
docker ps -a