问题:
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
这个问题,我们下一篇内容继续讲