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;