使用yum方式安装mysql

yum安装MySQL命令：

1.wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2.yum -y install mysql57-community-release-el7-8.noarch.rpm
3.yum -y install mysql-server

错误信息：

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

解决方法：

1.rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
2.yum install mysql-server

安装完成

1..systemctl start mysql
2.cat /var/log/mysqld.log | grep password 查看密码

设置密码格式

set global validate_password_policy=0;
set global validate_password_length=4;
set password=password('root');

关闭centos7防火墙

systemctl status firewalld;
systemctl stop firewalld;

设置mysql服务自动启动

systemctl enable mysqld.service #设置MYSQL服务自动启动
systemctl disable mysqld.service #关闭Mysql服务自动启动
systemctl restart mysqld.service #重启Mysql服务
systemctl status mysqld.service #查看Mysql服务状态

设置远程登录

update user set host = '%' where user ='root';