CentOS7.9安装Mysql5.7, 解决公钥未安装错误,设置root密码为空

一. 安装过程中的公钥未安装错误

安装命令：

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
cd /etc/yum.repos.d/
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
yum install mysql-server

错误信息：

mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm 的公钥尚未安装


 失败的软件包是：mysql-community-libs-compat-5.7.37-1.el7.x86_64
 GPG  密钥配置为：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

解决办法：

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

再次安装，成功

yum install mysql-server

二. 设置root 登录密码为空

启动mysql服务端mysqld后，因为没有配置root及密码，启动mysql客户端会出错

systemctl restart mysqld
mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

设置免密登录

vi /etc/my.cnf
#添加跳过密码验证
skip-grant-tables

重启mysql服务

systemctl restart mysqld

设置root登录密码为空

mysql -uroot
mysql> use mysql
mysql> update user set authentication_string='' where user='root';
mysql> quit

关闭免密登录

vi /etc/my.cnf
#注释掉跳过密码验证
#skip-grant-tables

重启mysql服务

systemctl restart mysqld

登录mysql客户端不需要密码, 出现提示输入密码时直接回车：

mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.37

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>