MySQL在CentOS安装

1、检查并卸载mariadb（新系统自带）

yum remove *mariadb*

2、下载并安装mysql源

下载地址：https://repo.mysql.com/

找到自己要下载的版本（这里以5.7为例）：

• mysql5.7可以使用mysql57-community-release-el7.rpm

• mysql8.0可以使用mysql80-community-release-el7.rpm

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

3、安装并启动mysql服务器

yum -y install mysql-community-server
systemctl start mysqld.service
systemctl enable mysqld.service
systemctl daemon-reload

4、修改mysql的root密码

修改root密码（默认root密码不能过于简单，否则会出现ERROR，需要设置两个参数使其可以设置简单密码）

grep "password" /var/log/mysqld.log
mysql -uroot -p
mysql> alter user 'root'@'localhost' identified by 'root';
ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen 
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
mysql> alter user 'root'@'localhost' identified by 'root';

5、开启远程访问

--赋予任何主机访问权限：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
--允许指定主机(IP地址)访问权限：
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'root' WITH GRANT OPTION;
--刷新权限表使修改生效
FLUSH PRIVILEGES;

查看mysql远程访问权限配置

select User,authentication_string,Host from mysql.user;

6、删除yum源并配置防火墙

yum -y remove mysql57-community-release.noarch
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload