砍材农夫

[toc]

docker快速部署mysql

拉取mysql镜像

docker pull mysql:8.0 docker pull mysql:5.7 针对上面不同版本，只需要将对应的版本调整下即可

第一种 mysql

docker run -di --restart=always --name=mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0

第二种 mysql

docker run -di --restart=always -p 3306:3306 --name mysql \
-v /usr/local/docker/mysql/conf:/etc/mysql \
-v /usr/local/docker/mysql/logs:/var/log/mysql \
-v /usr/local/docker/mysql/data:/var/lib/mysql \
-v /usr/local/docker/mysql/mysql-files:/var/lib/mysql-files \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:8.0

mysql安装之后

docker ps -a 查找到容器id
docker exec -it id /bin/bash 进入mysql容器
针对5.7

mysql -uroot -p123456
use mysql
update user set authentication_string = 'root' where user = 'root' and host = '%';
update user set authentication_string = 'root' where user = 'root' and host = 'localhost';
alter user 'root'@'%' identified with mysql_native_password by 'root';

针对8.0

mysql -uroot -p123456
use mysql
查询mysql加密方式
select host,user,plugin from user;
修改加密方式
alter user 'root'@'%' identified with mysql_native_password by 'root';

FLUSH PRIVILEGES;