安装mysql
安装docker
我是用野路子方法安装的,我现在有线环境下yum安装了,保存RPM包。
然后在离线的机器上安装的。
用yum解决依赖关系
下载镜像
docker pull mysql
创建挂载文件夹(不创建也行,挂载时会自动创建)
mkdir /data/mysql/{data,cnf,log,mysql-files} -p
编写my.cnf文件
在cnf文件夹下编写my.cnf文件
cd /data/mysql/cnf/
vim my.cnf
my.cnf文件内容
#Apply this config only on the master.
[client]
port = 3306
default-character-set = utf8mb4
[mysql]
port = 3306
default-character-set = utf8mb4
[mysqld]
# bind-address = 0.0.0.0
# port = 3306
max_connections=10000
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
# 设置时区和字符集
# default-time-zone='+8:00'
character-set-client-handshake=FALSE
init_connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'
gtid-mode=ON
enforce-gtid-consistency = ON
启动容器
docker run --restart=always --name mysql -v /data/mysql/cnf:/etc/mysql -v /data/mysql/data:/var/lib/mysql -v /data/mysql/log:/var/log -v /data/mysql/mysql-files:/var/lib/mysql-files -p 3306:3306 -e MYSQL_ROOT_PASSWORD='123456' -d mysql
验证mysql
docker exec -it mysql bash
mysql -uroot -p123456
远程连接时会报错
Authentication plugin 'caching_sha2_password'cannot be loaded
解决
使用root用户登录mysql
. 修改账户密码加密规则并更新用户密码
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
#更新一下用户的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
那边测试也能通过
lower_case_table_names = 1
wait_timeout = 2880000
interactive_timeout = 2880000
default-time_zone = ‘+8:00’
max_allowed_packet=1024M