安装Mysql
1、安装前准备
mysql安装的为docker版,安装mysql之前,需提前安装docker环境。详细可参考本栏目章节《CentOS下安装Docker(在线安装)》
Docker安装说明:
CentOS下安装Docker(在线安装)
2、安装mysql
服务器环境
服务器:192.168.1.110:3306
数据库账号:root root
挂载目录:/data/mysql
启停命令:docker start/stop/restart [容器id]
安装步骤
2.1、创建目录
mkdir -p /data/mysql/{conf,mysql,logs}
2.2、在目录下创建配置文件
vi /data/mysql/conf/my.cnf
[mysqld]
user=mysql
character-set-server=utf8
default-time_zone = '+8:00' #默认时区配置
default_authentication_plugin=mysql_native_password
secure_file_priv=/var/lib/mysql
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1000
lower_case_table_names=1 #表名不区分大小写
[mysqld_safe]
character_set_server = utf8
[mysql]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[client]
default-character-set = utf8
2.3、下载、运行镜像:
- 外网(可联网)
# 下载镜像
docker pull mysql:8.0.29
# 运行容器,挂在配置目录
docker run -p 3306:3306 --name mysql -v /data/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /data/mysql/logs:/logs -v /data/mysql/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=密码 -d mysql:8.0.29
-
内网(服务器不可联网)
在有外网的机器下将镜像下载下来,然后存储到磁盘,拷贝到对应的内网服务器
docker pull mysql:8.0.29
docker save -o /data/mysql/mysql8.0.29.tar mysql:8.0.29
# 加载mysql镜像文件
docker load -i /data/mysql/mysql8.0.29.tar
# 启动mysql,挂在配置目录
docker run -p 3306:3306 --name mysql8.0 --privileged -v /data/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /data/mysql/logs:/logs -v /data/mysql/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=密码 -d mysql:8.0.29
2.4、更改密码
# 进入容器
docker exec -it 容器ID /bin/bash
# 登录mysql
mysql -uroot -p
# 进行授权
GRANT ALL ON *.* TO 'root'@'%';
# 刷新权限
flush privileges;
# 设置密码加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxx' PASSWORD EXPIRE NEVER;
# 更新root密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxccccc';
# 刷新权限
flush privileges;