记一次centos8安装mysql8过程
1、创建文件夹：
cd /usr/local/
mkdir mysql
cd mysql
2、下载rpm
wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm
3、安装数据源：
yum install mysql80-community-release-el8-1.noarch.rpm
4、禁用自带mysql模块
yum module disable mysql
5、执行安装
yum install mysql-community-server
过程可能报错：GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
解决方法：
vi /etc/yum.repos.d/mysql-community.repo
修改 mysql80-community下面gpgcheck=0，保存退出，执行
yum clean packages
再次执行安装命令
6、启动
service mysqld start
查看启动状态
service mysqld status
7、查看随机密码
grep 'temporary password' /var/log/mysqld.log
8、用随机密码登录mysql
mysql -u root -p
9、修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
10、开启远程访问
create user 'root'@'%' identified by '密码';
grant all privileges on *.* to 'root'@'%' with grant option;
11、navicat连接报错
ALTER USER'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
ALTER USER'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;
12、连接完成。
参考：centos8安装mysql8.0.22 - 风子磊 - 博客园
