centos7安装mysql

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm mysql-community-release-el7-5.noarch.rpm
yum install mysql-server
systemctl start mysqld.service
#开机启动
systemctl enable mysqld
#关闭防火墙、永久
systemctl disable firewald
#关闭防火墙、当次
systemctl stop firewald


#设置mysql密码
use mysql;
update user set password = PASSWORD('密码') where user = '账号';
#刷新配置
flush privileges;

#创建账号
create user 'zengwenhe'@'%' identified with mysql_native_password by '123456';
#设置权限包括远程访问权限
grant all privileges on *.* to 'zengwenhe'@'%';
#刷新配置
flush privileges;