centos7安装mysql8.0.35

centos7安装mysql8.0.35
1.下载地址 https://dev.mysql.com/downloads/mysql/ ，选择OS Version及MySQL安装包
2.下载完之后，得到一个安装包：mysql-8.0.35-1.el7.x86_64.rpm-bundle.tar ，

tar -xf mysql-8.0.35-1.el7.x86_64.rpm-bundle.tar

3.卸载系统自带的MariaDB（MySQL）
安装之前卸载一下自带的MySQL（MariaDB）
查看安装过的MySQL和MariaDB：

yum list installed | grep mariadb && yum list installed | grep mysql

卸载

yum -y remove mariadb-libs.x86_64

4.安装MySQL 8
按顺序安装以下几个文件：

rpm -ivh mysql-community-common-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.35-1.el7.x86_64.rpm

5.在此安装过程中，遇到了如下问题：
mysql-community-devel 安装失败
解决方法：安装依赖 openssl-devel

yum install openssl-devel -y

mysql-community-server 安装失败
解决方法：安装依赖

yum install libaio

重新运行安装命令：

rpm -ivh mysql-community-server-8.0.35-1.el7.x86_64.rpm

6.查看安装完成后的安装包

rpm -qa |grep mysql

7.初始化MySQL服务
修改数据库目录与文件（默认/var/lib/mysql下）的所有者为mysql用户：

mysqld --initialize --user=mysql

该命令执行后会生成一个root的临时密码，在 /var/log/mysqld.log 文件中：

grep "password" /var/log/mysqld.log

8.启动MySQL服务

service mysqld start

9.使用临时密码登录

mysql -uroot -p

10.修改临时密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'nIM204!@';
FLUSH PRIVILEGES;
exit;

11.运行root用户来自任意主机的访问，不然无法远程连接mysql
 

CREATE USER 'root'@'%' IDENTIFIED BY 'nIM204!@';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
exit;

12.navicat远程连接失败，解决方法

sudo firewall-cmd --zone=public --add-port=3306/tcp --permanent
sudo firewall-cmd --reload