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

缺乏、安全感 2022-09-06 14:21 119阅读 0赞

### 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/

$ 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