MySQL5.7 yum 安装

MySQL5.7 yum 安装

作者：闫涛

E-mail：coderyantao@qq.com

备注：实验环境为selinux关闭、firewalld已关闭。

参考：https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

1.官网下载yum源

[root@localhost ~]# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

2.安装yum源

[root@localhost ~]# ls
mysql80-community-release-el7-3.noarch.rpm
[root@localhost ~]# yum install mysql80-community-release-el7-3.noarch.rpm 

3.修改mysql的yum源

[root@localhost ~]# vim /etc/yum.repos.d/mysql-community.repo 

修改如下两部分

# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
#启用5.7
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/
#关闭8.0
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

#查看mysql的yum源
[root@localhost ~]# yum list |grep mysql

4.官网下载MySQL5.7安装包

也可以直接使用下面的命令直接安装MySQL

yum install mysql-community-server.x86_64 

但是由于网络原因和经常使用，所以下载好一份安装包。

下载好之后使用sftp上传到Linux，md5校验

[root@localhost ~]# md5sum mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar 
56b94aef45542efdc8714423e0bd241f  mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar

此版本官网的值为：56b94aef45542efdc8714423e0bd241f。校验成功

5.安装mysql

#解压缩安装包
[root@localhost ~]# tar -xf mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar 

#安装mysql服务
[root@localhost ~]# yum install mysql-community-server-5.7.30-1.el7.x86_64.rpm

#启动mysql
[root@localhost ~]# systemctl start mysqld.service 

#开机启动mysql
[root@localhost ~]# systemctl enable mysqld.service

6.root默认密码

mysql5.7安装之后，生成默认密码在 /var/log/mysqld.log 里面，使用初始密码登录mysql

[root@localhost ~]# grep 'password' /var/log/mysqld.log 
2020-05-16T01:54:17.377567Z 1 [Note] A temporary password is generated for root@localhost: twb.F?&#M6sl
# twb.F?&#M6sl 就是默认密码

7.修改root密码

默认密码只能用来初次登录，必须修改、重新登录后才能操作数据库

[root@localhost ~]# mysql -u root -p
Enter password: #输入默认密码,进入数据库

mysql> alter user 'root'@'localhost' identified by 'MyNewPass4!';
Query OK, 0 rows affected (0.00 sec)
#退出
mysql> exit
Bye

8.新建管理员账号

新建管理员账号来替代root操作数据库。

mysql> create user 'admin'@'%' identified by 'MyNewPass4!';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to 'admin'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> 

或者一个库一个管理员

#重新登录创建一个库
mysql> create database shop;
Query OK, 1 row affected (0.00 sec)

#创建账号
mysql> create user 'shopadmin'@'%' identified by 'MyNewPass4!';
Query OK, 0 rows affected (0.00 sec)

#赋予admin用户shop库的所有权限
mysql> grant all on shop.* to 'shopadmin'@'%';
Query OK, 0 rows affected (0.00 sec)