docker mysql set mysql_native_password

#mysql8.0
#配置文件获取
docker pull mysql
docker run -di --name mysql -p 3306:3306 mysql
docker cp -rf mysql:/etc/mysql/my.cnf my.cnf
docker cp -rf mysql:/etc/mysql/conf.d conf.d
docker stop mysql
docker rm mysql

#修改配置文件
vi my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
#skip-grant-tables 免密登录mysql
#mysql_native_password----mysql caching_sha2_password
default_authentication_plugin=mysql_native_password

#创建docker容器实例
docker run -di --name=mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=mypassword -v /root/mysql/my.cnf:/        etc/mysql/my.cnf -v /root/mysql/conf.d:/etc/mysql/conf.d  mysql --default_authentication_plugin mysql_native_password


docker exec -it mysql /bin/bash
mysql -uroot -p
use mysql
delete from user where user='root' and host='%';
create user 'letgo'@'%' identified by 'letgopassword';
flush privileges;