How to change the user password of MySQL in the docker container

1. View the started MySQL container id

docker ps |grep mysql

2. Enter the started MySQL container

docker exec -it a00ba5071c1e /bin/bash

3. Modify the MySQL configuration file

Add skip-grant-tables code in the last line ( //Skip the password verification of mysql)

(if there is no password in the container For the vim command, you can use the commands apt-get update , apt-get install vim to download and install vim)

vim /etc/mysql/conf.d/docker.cnf

4. Restart the database

service mysql restart

5. Restart the MySQL container

docker restart a00ba5071c1e

6. Enter the started MySQL container again

docker exec -it a00ba5071c1e /bin/bash

6. Use the statement mysql -u root -p statement

to log in to the database without entering a password, just press Enter

mysql -u root -p

7.Use MySQL database

use mysql

8.Update user password

update user set authentication_string=password('123') where user="root";

9. Exit mysql

10. Edit the mysql configuration file again

Delete the just added skip-grant-tables

vim /etc/mysql/conf.d/docker.cnf

11. Restart mysql again

service mysql restart

12. Restart the docker container again

docker restart a00ba5071c1e

The above is the detailed content of How to change the user password of MySQL in the docker container. For more information, please follow other related articles on the PHP Chinese website!