Docker安装mysql

1

docker search mysql

1

docker pull mysql

1

docker run -it --restart always --name mysql   -v /opt/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3307:3306 -d mysql

1

docker ps

1

docker exec -it mysql /bin/bash

1

mysql -uroot -p123456

1
2

select   host,user,plugin,authentication_string   from   mysql.user;
# 备注：host为%表示不限制ip localhost表示本机  plugin非mysql_native_password 则需要修改密码

1
2

ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;