centos安装mysql5.6或者mysql5.7

本次用centos7安装mysql5.7为例

1，首先贴出不同centos对应的mysql的版本连接

mysql5.7 centos7:

https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

mysql5.7 centos6:

https://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm

mysql5.6 centos7:

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

mysql5.6 centos6:

https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

2，检查本地资源库是否有mysql的rpm包

rpm -qa | grep mysql
# 删除相关rpm包
yum -y remove  <相关rpm包>

3，搭建mysql5.7的yum源

# 下载mysql5.7的rpm包
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
# 安装第一步下载的rpm文件，安装成功后/etc/yum.repos.d/目录下会增加两个文件
yum -y install mysql57-community-release-el7-11.noarch.rpm
# 查看mysql57的安装源是否可用，如不可用请自行修改配置文件（/etc/yum.repos.d/mysql-community.repo）使mysql57下面的enable=1
# 若有mysql其它版本的安装源可用，也请自行修改配置文件使其enable=0
yum repolist enabled | grep mysql

4，安装mysql

yum install mysql-community-server

5，设置mysql

# 启动mysql服务
service mysqld start
# 查看root密码
grep "password" /var/log/mysqld.log
# 登陆mysql
mysql -u root -p
Enter password: 
# 为了可以设置简单密码
set global validate_password_policy=0;
set global validate_password_length=4;
# 立即修改密码，执行其他操作报错：
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
# 我们创建密码为123456
刷新权限
FLUSH PRIVILEGES;

6、设置权限，允许root用户操作mysql的hive数据库下面的表

 grant all on hive.* to 'root'@'%' identified by '123456' with grant option;
 FLUSH PRIVILEGES;
 

7、允许外部连接

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
FLUSH PRIVILEGES;