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

---

[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 \
-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 # 查看容器是否正常运行
vi /mysql/conf/my.cnf
=====配置内容=====
[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
init_connect='SET collation_connection = utf8mb4_unicode_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake

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;
show variables like 'character%'; # 查看字符编码