Solve the problem of deploying mysql8 in docker with correct password but unable to log in to MySQL

1、 Create and start the container , Do not set login password

$ docker run -p 3306:3306 --name mysql8 --privileged=true --restart unless-stopped -v  $PWD/conf:/etc/mysql/conf.d -v  $PWD/logs:/logs -v  $PWD/data:/var/lib/mysql -v /etc/localtime:/etc/localtime -e  -d mysql:8.0.26

2、 Into the container

$ docker exec -it mysql bash

3、 Modify the configuration file

3.1 Get into /etc/mysql/conf.d File directory ：

$ cd /etc/mysql/conf.d

3.2 establish MySQL The configuration file ：mysql.cnf

$ touch mysql.cnf

3.3 stay mysql.cnf Fill the configuration file with the following

[mysqld]
#  Skip password login 
skip-grant-tables

3.4 Exit the container , restart mysql Containers

$ exit
$ docker restart mysql

4、 Set up MySQL The login password

4.1 Re enter MySQL Containers , Sign in MySQL

$ docker exec -it mysql bash
$ mysql -uroot -p  #  No password required , Just enter twice directly 

4.2 Get into mysql surface

$ use mysql

4.3 Set up MySQL The login password

$ ALTER user 'root'@'%' IDENTIFIED BY ' The password you are about to set ';

4.4 Refresh the permissions

$ flush privileges;

That's all , Then use it normally .