Centos7使用repo安装Mysql-community

下载mysql-repo

rpm -ivh mysql80-community-release-el7-2.noarch.rpm
如果系统中已经安装mysql-community的repo，则使用rpm -Uvh mysql80-community-release-el7-2.noarch.rpm来更新;

安装的repo默认启用mysql80-community版本，如果需要安装mysql57-community则使用yum-config-manager来启用
启用mysql57安装源
1. 安装yum-utils yum install yum-utils -y
2. 禁用mysql80安装源 yum-config-manager --disable mysql80-community
3. 启用mysql57安装源 yum-config-manager --enable mysql57-community
4. 查看启用的mysql安装源 yum repolist enabled | grep mysql

安装
- yum install mysql-community-server -y
启动mysql
- systemctl start mysqld
查看mysql默认密码
- cat /var/log/mysqld.log | grep passw
修改root密码
- mysql -u root -p #使用默认的密码登录mysql
- alter user 'root'@'localhost' identified by 'NewPasswd2019!'; #新的密码要符合mysql的密码策略，否则会出错
- flush privileges;
授权用户
- create user db_user identified by 'newPasswd';
- create database test;
- grant all on test.* to 'db_user'@'192.168.0.90' identified by 'newPasswd';
- flush privileges;

查看防火墙状态
- firewall-cmd --zone=public --list-all
添加rich-rule
- firewall-cmd --zone=public --add-rich-rule='rule family="ipv4" source address="192.168.0.90/24" port port="3306" protocol="tcp" accept' –permanent
- firewall-cmd --reload