Centos7 安装mysql5.6

Centos7 安装mysql5.6

1.下载rpm包

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
查看当前可用的mysql安装资源

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;