参考：
安装docker
下载镜像
运行镜像
1
| docker run --name mysql -p 3306:3306 -v /app/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql
|
进入mysql进行设置
1
2
3
| docker ps -a --获取mysql 容器的id
docker exec -it 容器id sh
|
进入Mysql后登录mysql
1
2
3
| mysql -uroot -proot
若报root@localhost,请试试mysql -uroot
|
创建数据库用户
1
2
3
4
5
| create USER springcloud IDENTIFIED WITH mysql_native_password BY '123456';
grant all privileges on *.* to springcloud;
create database springclouddb
|
报错信息
若show databases 报错
若是 缺没有此mysql.infoschema用户
则执行以下sql
1
2
3
4
5
6
7
8
9
10
11
12
13
| create USER 'mysql.infoschema' IDENTIFIED WITH mysql_native_password BY '123456';
create USER 'mysql.session' IDENTIFIED WITH mysql_native_password BY '123456';
create USER 'mysql.sys' IDENTIFIED WITH mysql_native_password BY '123456';
create USER springcloud IDENTIFIED WITH mysql_native_password BY '123456';
grant all privileges on *.* to 'mysql.infoschema';
grant all privileges on *.* to 'mysql.session';
grant all privileges on *.* to 'mysql.sys';
|
