docker exec mysql报ERROR 2002 和ERROR 2003错误的解决办法

cjd007

已于 2023-02-09 10:14:04 修改

阅读量347

点赞数

文章标签： mssql docker Powered by 金山文档

于 2023-02-09 09:56:58 首次发布

本文链接：https://blog.csdn.net/cjd007/article/details/128947552

版权

mysql安装完了，需要进行一下设置，客户端才能连接，这里采用docker方式安装，然后采用shell执行sql脚本来初始化时报错：

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

ERROR 2003 (HY000): Can't connect to MySQL server on '0.0.0.0:3306' (111)

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (101)

调试后终于不报错了，现在把shell脚本记下来：

# 获取 该容器实例的ip
mysql_docker_ip=$(docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' my_mysql)
echo "容器实例ip:$mysql_docker_ip"
exe_sqls="GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '"$MYSQL_ROOT_PASSWORD"';flush privileges;"
docker exec -id $CNT_NAME mysql -h$mysql_docker_ip -P$MYSQL_PORT --protocol=tcp -uroot -p$MYSQL_ROOT_PASSWORD -e "${exe_sqls}"

注意点：