[系统运维]centos8 安装mysql8

记一次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 - 风子磊 - 博客园