Docker安装Mysql及配置

Docker安装mysql

# 拉取镜像
docker pull mysql
# 拉取制定版本
docker pull mysql:5.7

docker run -p 3306:3306 \
    --name my-mysql \
    -v $PWD/conf:/etc/mysql \
    -v $PWD/data:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD=123456 \
    -d mysql:5.7

# 带挂载启动
docker run -p 3306:3306 --name mysql \
    -v /usr/local/docker/mysql/conf:/etc/mysql \
    -v /usr/local/docker/mysql/logs:/var/log/mysql \
    -v /usr/local/docker/mysql/data:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD=123456 \
    -d mysql:5.7

# 检查mysql是否正常可用
docker exec -it mysql /bin/bash
mysql -uroot -p123456

配置防火墙

# 防火墙放开端口
systemctl status firewalld
firewall-cmd --zone=public --add-port=3306/tcp -permanent
firewall-cmd --reload

# 关闭防火墙
systemctl stop firewalld

配置用户

# 设置远程访问账号
mysql> grant all privileges on *.* to root@'%' identified by "123456";

# 创建一个专属的用户，控制权限
mysql> create user 'username'@'%' identified by 'password';

# 修改用户权限
mysql> grant all on 'database'.'tableName' to 'username'@'%' identified by 'password';

# 查看用户权限
mysql> show grants for 'username'@'%'

# 删除用户
mysql> drop user 'username'@'%'