1:检查yum是否有 mysql-server的 repo
rpm -qa|grep mysql
2:安装repo
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
3:安装mysql
yum install mysql-server
4:启动mysql
systemctl start mysqld
systemctl enable mysqld.service //开机启动
5:设置密码
1)登录mysql
mysql -u root
2)mysql内设置密码
use mysql;
update user set password=password('我的密码') where user='我的用户名';
grant all privileges on *.* to '我的用户名'@'%' identified by '我的密码'; //授权远程登录
FLUSH PRIVILEGES;//重载授权表
exit;
CREATE DATABASE 我的数据库;
6:开放端口
firewall-cmd --query-port=3306/tcp //查看端口是否开放
firewall-cmd --zone=public --add-port=3306/tcp --permanent //--permanent永久生效
firewall-cmd --reload //重启防火墙