docker mysql

1.　　docker run -p 3306:3306 -v /opt/docker_v/mysql/conf:/etc/my.cnf -e MYSQL_ROOT_PASSWORD=123456 mysql

2.　　docker exec -it 2736cca8f304 bash

3.　　grant all privileges on *.* to 'root'@'%';

4.　　ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';

 

 

5.  ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
6.  ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';