Docker安装MySQL

Dokcer使用—Docker安装MySQL

1.拉取镜像

docker pull mysql:5.7

2.创建mysql容器并运行

#mysql:5.7
docker run \
--name mysql \
-d \
-p 3306:3306 \
--restart unless-stopped \
-v /usr/local/mysql/log:/var/log/mysql \
-v /usr/local/mysql/data:/var/lib/mysql \
-v /usr/local/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
mysql:5.7

#mysql:8.0.27
docker run \
--name mysql \
-d \
-p 3306:3306 \
--restart unless-stopped \
-v /usr/local/mysql8/log:/var/log/mysql \
-v /usr/local/mysql8/data:/var/lib/mysql \
-v /usr/local/mysql8/mysql-files:/var/lib/mysql-files \
-v /usr/local/mysql8/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
mysql:8.0.27

3.进入容器 进入数据库

## 通过Docker命令进入Mysql容器内部
docker exec -it mysql /bin/bash
## 或者
docker exec -it mysql bash

4，远程链接的话需要设置权限

8.0没有密码 需要设置

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘密码’;

8.0设置权限会报错
就先去把root用的host改成%，再运行上面那句话。

#8.0
use mysql;
select Host, User from user;
update user set Host=‘%’ where User=‘root’;
alter user 'root'@'%' identified with mysql_native_password by '123456';

#5.7
grant all privileges on *.* to root@'%' identified by 'root';
flush privileges;