docker mysql 报错_docker 安装mysql8.0 挂载后报错 ERROR 2002 (HY000): Can't connect to local MySQL server thro...

问题：

docker中安装mysql

过程：

1、安装mysql镜像docker pull mysql:8.0.20

2、运行mysqldocker run -itd --name mysql -p 3306:3306 -v /var/www/html/mysql/mysqld:/var/run/mysqld:rw -v /var/www/html/mysql/db:/var/lib/mysql:rw -v /var/www/html/mysql/conf:/etc/mysql/conf.d:rw -v /var/www/html/mysql/files:/var/lib/mysql-files:rw --restart=always -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0.20

3、连接mysqlmysql -h localhost -u root -p

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

解决方法

方法其实挺简单，只需要将“localhost”给为“127.0.0.1”，即mysql -h 127.0.0.1 -u root -p

但此时会遇到另一个问题ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 2

这个问题，我们下一篇内容继续讲