Centos 7安装mysql8.0和配置远程连接

1、配置安装源

sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

2、换密钥配置

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

3、安装mysql8.0

sudo yum --enablerepo=mysql80-community install mysql-community-server

4、启动服务

systemctl start mysqld;

5、查看临时密码

grep “A temporary password” /var/log/mysqld.log;
cat /var/log/mysqld.log | grep password

6、配置远程服务

查看默认mysql用户
输入：use mysql;
输入：select host, user, authentication_string, plugin from user;
发现root的host是localhost，不是%，可以加个host是%的root账号：
输入：CREATE USER 'root'@'%' IDENTIFIED BY 'Sed123456+';
create user 'root'@'%' identified with mysql_native_password by 'Sed123456+';
若创建错误，提供删除语句：
输入：Delete FROM user Where User='root' and Host='%';
然后为用户授权：
grant all privileges on *.* to 'root'@'%';
最后刷新权限：flush privileges;
退出mysql:
quit;

7、修改默认端口

vi /etc/my.cnf
port=xxx