原谅如此简单粗暴hah~~
- 拉取镜像
docker pull mysql:5.7.26
- 创建mysql数据相关的挂载目录
mkdir -p /usr/local/workspace/mysql/data
/usr/local/workspace/mysql/log
/usr/local/workspace/mysql/conf
- 启动命令
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
- 进入容器操作数据库:
docker exec -it mysql /bin/bash
mysql -uroot -p;
- 创建用户并授权
GRANT ALL PRIVILEGE`在这里插入代码片`S ON *.* TO '用户名'@'ip地址' IDENTIFIED BY '密码' WITH GRANT OPTION;
- 刷新
flush privileges;
- 退出数据库
quit;
8.远程连接使用