docker部署mysql · SpringCloud微服务实战 · 看云

1.下载MySQL5.7的镜像文件

docker pull mysql/mysql-server:5.7


[root@iZm5e9qft3zum0ofqa48l2Z docker]# docker pull mysql/mysql-server:5.7
5.7: Pulling from mysql/mysql-server
a316717fc6ee: Pull complete 
b64762744f75: Pull complete 
a1f742e3aa43: Pull complete 
f71a5f0dcc26: Pull complete 
Digest: sha256:5396bc60a6c08abb6b7e8350b255324a91ee9f3ea11f009aea3e4b61ead38bf6
Status: Downloaded newer image for mysql/mysql-server:5.7
docker.io/mysql/mysql-server:5.7

2. 启动一个MySQL容器

docker run --name=mysql5.7 -p 3306:3306  -d mysql/mysql-server:5.7 --lower_case_table_names=1

2.1 查看日志

docker logs mysql5.7

2.2 登录mysql

docker exec -it mysql5.7 mysql -uroot -p

2.3 重置mysql密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '134562';

2.4 更改localhost 设置外网访问

use mysql;
update user set host='%' where user='root';

2.5刷新一下权限生效

flush privileges;

3. 创建用户

create user 'xuyisu'@'%' identified by '123456';

3.1 给某个数据库授权给用户

grant all privileges on `dbname`.* to 'xuyisu'@'%' identified by '123456' with grant option;

3.2 给所有数据库授权给用户

grant all privileges on *.* to 'xuyisu'@'%' identified by '123456' with grant option;

4. 直接设置密码、时区、默认字符集

docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -e TZ="Asia/Shanghai" -d mysql/mysql-server:5.7  --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci  --lower_case_table_names=1