CentOS7 MySQL 8 Install & Configuration

1. Environment

• 官网下载

  https://dev.mysql.com/downloads/mysql/

  https://cdn.mysql.com/Downloads/MySQL-8.0/mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar

  https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar

2. Install

• 将安装包通过SFTP上传至Centos7 服务器中指定目录，这里放在/opt目录下

  cd /opt
  ls -l
  

• 创建安装目录

  mkdir -p /usr/local/mysql/
  

• 解压至安装目录

  • Mysql 8.0 依照需要安装的mysql版本选择

  tar -xvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/
  

  • Mysql 5.7

  tar -xvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar  -C /usr/local/mysql/
  

• 查看 mariadb 的安装包

  rpm -qa | grep mariadb
  

• 装卸 mariadb

  rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
  

• 再次查看 mariadb 的安装包

  rpm -qa | grep mariadb
  

• 进入安装目录

  cd /usr/local/mysql/
  

• 安装 common

  rpm -ivh mysql-community-common-8.0.22-1.el7.x86_64.rpm --nodeps --force
  
  rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm --nodeps --force
  

• 安装 libs

  rpm -ivh mysql-community-libs-8.0.22-1.el7.x86_64.rpm --nodeps --force
  
  rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm --nodeps --force
  

• 安装 client

  rpm -ivh mysql-community-client-8.0.22-1.el7.x86_64.rpm --nodeps --force
  
  rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm --nodeps --force
  

• 安装 server

  rpm -ivh mysql-community-server-8.0.22-1.el7.x86_64.rpm --nodeps --force
  
  rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm --nodeps --force
  

• 查看 mysql 的安装包

  rpm -qa | grep mysql
  

3. Configuration

• 修改MySQL端口号，新密码，这里暂定AAAAAA

  vim /etc/my.cnf
  

• 在socket=/var/lib/mysql/mysql.sock下一行 添加如下代码

  port=33096
  lower_case_table_names=1
  

• 在pid-file=/var/run/mysqld/mysqld.pid下一行 添加如下代码

  [mysqldump]
  user=root
  password=AAAAAA
  

• 对 mysql 数据库的初始化和相关配置

  mysqld --initialize;
  chmod -R 777 /var/lib/mysql
  chown mysql:mysql /var/lib/mysql -R;
  systemctl start mysqld.service;
  systemctl enable mysqld;
  

• 重启启动mysql服务

  systemctl restart mysqld
  

4. Configuration Database

• 查看数据库的密码 8YTtokUu&)a2

  cat /var/log/mysqld.log | grep password
  

• 进入数据库登陆界面

  mysql -uroot -p
  

• 修改密码为 新密码，这里暂定AAAAAA

  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'AAAAAA';
  

• 验证是否修改成功

  exit;
  mysql -u root -p
  输入新密码
  

• 远程访问的授权

  create user 'root'@'%' identified with mysql_native_password by 'AAAAAA';
  grant all privileges on *.* to 'root'@'%' with grant option;
  flush privileges;
  

• 修改加密规则

  ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
  GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'AAAAAA' WITH GRANT OPTION;
  flush privileges;
  

4. Configuration 防火墙

• 查看Mysql使用端口33096

  netstat -lnpt
  

• 开放端口，这里使用33096端口

  firewall-cmd --permanent --zone=public --add-port=33096/tcp
  

• 重启防火墙

  firewall-cmd --reload
  

• 查看防火墙，已开放端口列表

  firewall-cmd --list-ports