1.docker-compose配置:
version: '3.7'
services:
mysql:
container_name: mysql
image: mysql:8.0
restart: always
ports:
- 13306:3306
privileged: true #选项解析(特权模式:赋予容器几乎与主机相同的权限)
volumes:
- /Users/kuangjiacheng/dockerapp/mysql/log:/var/log/mysql
- /Users/kuangjiacheng/dockerapp/mysql/conf/my.cnf:/etc/mysql/my.cnf
- /Users/kuangjiacheng/dockerapp/mysql/data:/var/lib/mysql
environment:
MYSQL_ROOT_PASSWORD: yourpassword # root用户密码
command: [
'--default-authentication-plugin=caching_sha2_password',
'--character-set-server=utf8mb4',
'--collation-server=utf8mb4_general_ci',
'--explicit_defaults_for_timestamp=true',
'--lower_case_table_names=1',
'--max_allowed_packet=128M',
'--max_connections=3000'
]
2.my.conf配置
[mysqld]
skip-name-resolve
skip-grant-tables
default-storage-engine=INNODB
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
user=root
#实现mysql不区分大小(开发需求,建议开启)
lower_case_table_names=1
# By default we only accept connections from localhost
#bind-address = 127.0.0.1
bind-address = 0.0.0.0
# Disabling symbolic-links is recommended to prevent assorted security risks
# 更改字符集 如果想Mysql在后续的操作中文不出现乱码,则需要修改配置文件内容
symbolic-links=0
character-set-server=utf8mb4
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
[client]
default-character-set=utf8mb4
# 设置数据库日志过期时间为14天(8.0以上失效)
# expire_logs_days = 14
[mysql]
default-character-set=utf8mb4
3.提前准备好mysql的配置文件
其中conf下的my.conf需要手动添加
4.通过docker命令拉取镜像并启用
进入docker-compose-middleware.yml文件所在的文件夹目录
docker-compose -f docker-compose-middleware.yml up -d
5.修改mysql登录密码
5.1在my.conf中,修改密码认证
mysql8.0密码认证插件已经由mysql_native_password改为caching_sha2_passwor
5.2 修改mysql容器中的密码
(1)[mysqld]中,先设定为了root无密码登录。
skip-name-resolve
skip-grant-tables
(2)%和localhost的root的用户登录,密码验证插件设置为:mysql_native_password
# 进入mysql容器
docker exec -it mysql容器ID /bin/sh
# 登录mysql
mysql -u root -p
# 提示输入密码,直接enter即可
# 使用mysql数据库
use mysql;
# 查询mysql账户表信息
select host, user, authentication_string, plugin from user;
# 修改host可以远程访问
UPDATE mysql.user SET Host='%'WHERE User='root'AND Host='localhost';
# 刷新权限
FLUSH PRIVILEGES;
# 修改root密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your password';
# 刷新权限
FLUSH PRIVILEGES;
# 退出mysql,退出容器
exit;
将无密码登录注释掉
# skip-name-resolve
# skip-grant-tables
# 重启mysql容器
docker restart 容器id;
# 此时root账号可以远程访问了
重启后,navicat即可连接docker下的mysql了。