MySQL（二）yum源与rpm包方式安装

一、yum源方式安装

1、官网下载包

https://dev.mysql.com/downloads/repo/yum/

2、安装

[root@www ~]# yum install -y https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

[root@www ~]# ls /etc/yum.repos.d/

3、过滤

[root@www ~]# yum list | grep "mysql-community"

mysql-community-server.x86_64 5.7.19-1.el7 mysql57-community

mysql-community-client.x86_64 5.7.19-1.el7 mysql57-community

4、安装服务端和客户端

[root@www ~]# yum install mysql-community-client mysql-community-server -y

5、启动

[root@www etc]# systemctl start mysqld

6、登录

[root@www etc]# mysql -uroot -p

Enter password:

提示无法登录

7、跳过密码登录

[root@www etc]# vim /etc/my.cnf

写入下面一行：

skip-grant-tables

8、重启服务并登录

[root@www etc]# systemctl restart mysqld

[root@www etc]# mysql -uroot -p

直接回车跳过密码，即可进入数据库；

mysql> use mysql

修改密码：

mysql> update user set authentication_string=password('123456') where user='root' and Host = 'localhost';

9、密码登录

[root@www etc]# vim /etc/my.cnf

再注释下面一行：

#skip-grant-tables

[root@www etc]# systemctl restart mysqld

[root@www etc]# mysql -uroot -p

Enter password:123456

登录成功！

二、rpm方式安装

1、官网获取链接地址

     www.mysql.com

     DOWNLOAD

     点击右上角Archives

     点击第一个 MySQL Community Server

     Product Version:  5.7.18 

     Operating System: Red Hat Enterprise Linux 7 / Oracle Linux

     

   

鼠标在Download处右击复制链接地址；

2、安装

(1)、安装需要工具：

[root@localhost ~]# yum install ntpdate wget vim bsh-completion net-tools -y

[root@localhost ~]#mkdir tools

[root@localhost ~]#cd tools

(2)、获取安装包

[root@localhost tools]# wget https://downloads.mysql.com/archives/get/file/mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar

(3)、解压包

[root@localhost tools]# tar xf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar  ---在安装包的路径下；

(4)、查看解压的包

[root@localhost tools]# ls

mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar

mysql-community-client-5.7.18-1.el7.x86_64.rpm

mysql-community-common-5.7.18-1.el7.x86_64.rpm

mysql-community-devel-5.7.18-1.el7.x86_64.rpm

mysql-community-embedded-5.7.18-1.el7.x86_64.rpm

mysql-community-embedded-compat-5.7.18-1.el7.x86_64.rpm

mysql-community-embedded-devel-5.7.18-1.el7.x86_64.rpm

mysql-community-libs-5.7.18-1.el7.x86_64.rpm

mysql-community-libs-compat-5.7.18-1.el7.x86_64.rpm

mysql-community-minimal-debuginfo-5.7.18-1.el7.x86_64.rpm

mysql-community-server-5.7.18-1.el7.x86_64.rpm

mysql-community-server-minimal-5.7.18-1.el7.x86_64.rpm

mysql-community-test-5.7.18-1.el7.x86_64.rpm

(5)、安装

安装客户端：

step1:

[root@localhost tools]# yum localinstall mysql-community-client-5.7.18-1.el7.x86_64.rpm

提示需要：mysql-community-libs(x86-64) >= 5.7.9包

step2:安装libs包:

[root@localhost tools]# yum localinstall mysql-community-libs-5.7.18-1.el7.x86_64.rpm

提示需要：mysql-community-common(x86-64) >= 5.7.9包

step3:安装common包:

[root@localhost tools]# yum localinstall mysql-community-common-5.7.18-1.el7.x86_64.rpm

提示与已安装的mariadb相关的包发生冲突，所以需要移除mariadb相关的包；

step4: 移除mariadb相关包：

[root@localhost tools]# rpm -aq |grep mariadb

mariadb-libs-5.5.52-1.el7.x86_64

[root@localhost tools]# rpm -e mariadb-libs-5.5.52-1.el7.x86_64

提示此包被已安装的postfix相关包需要，所以先移除postfix相关包；

[root@localhost tools]# rpm -e mariadb-libs postfix-2:2.10.1-6.el7.x86_64

此处若么有任何报错说明移除成功，然后再按刚才相反的步骤一步一步安装即可；

[root@localhost tools]# rpm -e mariadb-libs-5.5.52-1.el7.x86_64

[root@localhost tools]# yum localinstall mysql-community-common-5.7.18-1.el7.x86_64.rpm

[root@localhost tools]# yum localinstall mysql-community-libs-5.7.18-1.el7.x86_64.rpm

[root@localhost tools]# yum localinstall mysql-community-client-5.7.18-1.el7.x86_64.rpm

以上表明客户端已经安装成功，再安装服务端：

安装服务端：

[root@localhost tools]# yum localinstall mysql-community-server-5.7.18-1.el7.x86_64.rpm

(6)、查看已安装的包

[root@localhost tools]# rpm -aq |grep ^mysql

mysql-community-common-5.7.18-1.el7.x86_64

mysql-community-client-5.7.18-1.el7.x86_64

mysql-community-libs-5.7.18-1.el7.x86_64

mysql-community-server-5.7.18-1.el7.x86_64

(7)、查看主配置文件

[root@localhost tools]# rpm -ql mysql-community-server

/etc/my.cnf

(8)、退出安装路径并启动mysql

[root@localhost ~]# systemctl start mysqld

[root@localhost ~]# systemctl enable mysqld

(9)、监听端口

[root@localhost ~]# netstat -an |grep 3306

(10)、寻找密码

[root@localhost ~]# more /var/log/mysqld.log

相关行 A temporary password is generated for root@localhost: WJ<y0jkx1gA5 

(11)、登录

[root@localhost ~]# mysql -uroot -p

Enter password:

(12)、修改简单密码

方法一：

mysqladmin -uroot -p 'WJ<y0jkx1gA5' password '123456'

方法二：

mysql> alter user'root'@'localhost'identified by '[e-mail]';

或者

mysql> set password=password('[e-mail]');

安装成功！！！