centos7安装mysql

centos7安装mysql

1.下载rpm包

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

2.查看当前可用的mysql安装资源

yum repolist enabled | grep "mysql.*-community.*"

3.Yum安装

yum -y install mysql-community-server

4.启动mysql

service mysqld start

5.查看运行状态

service mysqld status

6.设置密码

mysql_secure_installation 按回车
 Enter current password for root (enter for none): 按回车
Set root password? [Y/n] y  设置root账号密码
New password：输入新密码
Re-enter new password：再次输入
Remove anonymous users? [Y/n] Y 删除匿名用户
Disallow root login remotely? [Y/n] n 禁止远程登录
Remove test database and access to it? [Y/n] n  删除test数据库
Reload privilege tables now? [Y/n] y   刷新权限

7.关闭防火墙

systemctl stop firewalld.service

8.授权远程访问

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;