docker 解决8.0mysql远程登陆问题[HY000][1130] null, message from server: “Host ‘192.168.5

[HY000][1130] null, message from server: "Host '192.168.56.1' is not allowed to connect to this MySQL server". 在这里插入图片描述

docker search mysql
docker pull mysql8.0.26 # 拉取mysql
docker images mysql
ps -ef | grep mysql # 注意docker mysql端口和宿主机端口冲突

# -----------------数据备份-----------------
docker run -d -p 3306:3306 --privileged=true \
-v /mysql/log:/var/log/mysql \
-v /mysql/data:/var/lib/mysql \
-v /mysql/conf:/etc/mysql/conf \
-v /mysql/mysql-files:/var/lib/mysql-files/ \
-e TZ=Asia/Shanghai \
--restart=always \
-e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql:8.0.26 \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_unicode_ci \
--default-authentication-plugin=mysql_native_password

# -----------------------------------------

docker ps # 查看容器是否正常运行

docker exec -it mysql bash 进入mysql容器 mysql -uroot -p 第一次登陆无密码 开启root用户mysql远程登陆

use mysql;
update user set host='%' where user='root';
Grant all privileges on root.* to 'root'@'%';  #执行两次
alter user root identified with mysql_native_password by '123456';
FLUSH PRIVILEGES;

在这里插入图片描述