CentOS7安装MySQL8数据库

1、安装包下载

下载地址:  https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

2、解压

tar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

3、安装

1. 安装common

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

   警告：mysql-community-common-8.0.19-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
   准备中...                          ################################# [100%]
   正在升级/安装...
      1:mysql-community-common-8.0.19-1.e################################# [100%]

2. 安装libs

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

   警告：mysql-community-libs-8.0.19-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
   准备中...                          ################################# [100%]
   正在升级/安装...
      1:mysql-community-libs-8.0.19-1.el7################################# [100%]

3. 安装client

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

   警告：mysql-community-client-8.0.19-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
   准备中...                          ################################# [100%]
   正在升级/安装...
      1:mysql-community-client-8.0.19-1.e################################# [100%]

4. 安装server

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

   警告：mysql-community-server-8.0.19-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
   准备中...                          ################################# [100%]
   正在升级/安装...
      1:mysql-community-server-8.0.19-1.e################################# [100%]

5. 查看安装结果

   rpm -qa | grep mysql

   mysql-community-common-8.0.19-1.el7.x86_64
   mysql-community-client-8.0.19-1.el7.x86_64
   mysql-community-libs-8.0.19-1.el7.x86_64
   mysql-community-server-8.0.19-1.el7.x86_64

4、数据库配置

1. 初始化及服务配置

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

2. 密码修改

   #查看初始密码
   

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

   2020-04-03T03:44:00.344470Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Dosk._BIl6tE

    登录：

   mysql -uroot -p

   修改密码：

   mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' ;

3. 远程访问授权

   mysql> create user 'root'@'%' identified with mysql_native_password by '123456';

   Query OK, 0 rows affected (0.00 sec)
   
   mysql>

   mysql> grant all privileges on *.* to 'root'@'%' with grant option;

   Query OK, 0 rows affected (0.01 sec)
   
   mysql>

   mysql> flush privileges;

   Query OK, 0 rows affected (0.01 sec)

提示：mysql8之后的数据库连接驱动为 com.mysql.cj.jdbc.Driver