Docker部署Mysql数据库

原谅如此简单粗暴hah~~

1. 拉取镜像

docker pull mysql:5.7.26

2. 创建mysql数据相关的挂载目录

mkdir -p /usr/local/workspace/mysql/data 
	     /usr/local/workspace/mysql/log
		 /usr/local/workspace/mysql/conf 

3. 启动命令

docker run -p 3306:3306 --name mysql 
		-v /usr/local/workspace/mysql/log:/var/log/mysql 
		-v /usr/local/workspace/mysql/data:/var/lib/mysql 
		-v /usr/local/workspace/mysql/conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=123456 
		-d mysql:5.7.26

4. 进入容器操作数据库：

docker exec -it mysql /bin/bash

mysql -uroot -p;

5. 创建用户并授权

GRANT ALL PRIVILEGE`在这里插入代码片`S ON *.* TO '用户名'@'ip地址' IDENTIFIED BY '密码' WITH GRANT OPTION;

6. 刷新

flush privileges;

7. 退出数据库

quit;

8.远程连接使用