centos安装mysql

下载mysql仓库并安装

wget https://repo.mysql.com/mysql57-community-release-el7.rpm
yum -y install mysql57-community-release-el7.rpm

安装mysql数据库

yum -y install mysql-community-server

如果遇到报错如下报错，则执行下面的命令，原因是mysql的gpg升级了

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

Public key for mysql-community-libs-compat-5.7.38-1.el7.x86_64.rpm is not installed
Failing package is: mysql-community-libs-compat-5.7.38-1.el7.x86_64
GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

开启服务

systemctl start mysqld.service

生成默认root密码

cat /var/log/mysqld.log | grep password

修改root密码(密码必须有一定复杂度，否则被拒绝)

 set password for root@localhost =password('asdsd￥%……');

添加账户

create user 'glt'@'%' identified by '%5245dsfdfd'# %的意思是任意ip可访问，后面是密码
flush privileges                                 # 刷新权限

root账号远程访问

use mysql;
update user set host = '%' where user = 'root';
flush privileges;