centos6.10使用官方源yum安装mysql5.7

mysql安装：
官方文档：https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
1.添加对应的yum仓库
EL6-based system：
shell> sudo yum localinstall mysql57-community-release-el6-{version-number}.noarch.rpm
EL7-based system:
shell> sudo yum localinstall mysql57-community-release-el7-{version-number}.noarch.rpm
EL8-based system:
shell> sudo yum localinstall mysql57-community-release-el8-{version-number}.noarch.rpm
2.选择软件发行版本
#查看mysql的yum源列表
shell> yum repolist all | grep mysql
#使用yum工具启用或者禁用yum源（安装yum工具：yum -y install yum-utils）
shell> sudo yum-config-manager --disable mysql57-community
shell> sudo yum-config-manager --enable mysql56-community
#或者手动编写进yum配置文件中
/etc/yum.repos.d/mysql-community.repo
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
#查看启用的yum源是否有对应的发行版本的源
shell> yum repolist enabled | grep mysql
3.安装mysql
shell> sudo yum install mysql-community-server
4.启动服务
[root@zabbix-master yum.repos.d]# service mysqld start
Initializing MySQL database:                               [  OK  ]
Starting mysqld:                                           [  OK  ]
#查看服务状态
shell> sudo service mysqld status
mysqld (pid 3066) is running.
#查看初始化生成的密码
shell> sudo grep 'temporary password' /var/log/mysqld.log
#修改密码
shell> mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
#添加root用户远程连接权限
grant all privileges on *.* to 'root'@'%' identified by 'passwd';
flush privileges;

#移除权限
revoke delete on *.* from 'jack'@'localhost';
#显示授权
show grants;
#删除用户
drop user 'jack'@'localhost';
#改名
rename user 'jack'@'%' to 'jim'@'%';