Centos7 更新mysql5.6到Mysql5.7-折腾笔记

由于之前的机器安装了mysql5.6,现在想升级到mysql5.7。

一、卸载mysql-5.6

初级思路:

1、卸载mysql5.6

2、升级到mysql5.7

初级思路遇到的问题:

1、卸载mysql 5.7后,使用Google的方式,安装mysql57-community-release-el7-7.noarch.rpm时遇到了问题,原因是:

Error: mysql57-community-release conflicts with mysql-community-release-el7-5.noarch
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

然后使用以下命令安装:

# rpm -i  mysql57-community-release-el7-7.noarch.rpm 
error: Failed dependencies:
	mysql-community-release conflicts with mysql57-community-release-el7-7.noarch

结果也不行!

然后我尝试卸载冲突项,系统提示冲突项不存在!!

解决方法:使用rpm -qa 查找已安装包

[root@localhost ~]#  rpm -qa | grep mysql 
mysql-community-release-el7-5.noarch
mysql-community-common-5.6.35-2.el7.x86_64
mysql-community-libs-5.6.35-2.el7.x86_64

然后依次卸载:

[root@localhost ~]# rpm -e --nodeps mysql-community-release-el7-5.noarch
[root@localhost ~]# rpm -e --nodeps mysql-community-common-5.6.35-2.el7.x86_64
[root@localhost ~]# rpm -e --nodeps mysql-community-libs-5.6.35-2.el7.x86_64
yum remove mysql-server

二、安装Mysql5.7

1、下载源

wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

2、安装源

yum localinstall mysql57-community-release-el7-7.noarch.rpm

3、确认并安装

# yum install mysql-server

版本确认:

Dependencies Resolved

===========================================================================================================================
 Package                          Arch             Version                               Repository                   Size
===========================================================================================================================
Installing:
 mysql-community-server           x86_64           5.7.17-1.el7                          mysql57-community           162 M
Installing for dependencies:
 mysql-community-client           x86_64           5.7.17-1.el7                          mysql57-community            24 M
 mysql-community-common           x86_64           5.7.17-1.el7                          mysql57-community           271 k
 mysql-community-libs             x86_64           5.7.17-1.el7                          mysql57-community           2.1 M
 net-tools                        x86_64           2.0-0.17.20131004git.el7              base                        304 k

Transaction Summary
===========================================================================================================================
Install  1 Package (+4 Dependent packages)

四、确认版本

[root@localhost ~]# mysql --version
mysql  Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using  EditLine wrapper

 

三、改变root密码

0、启动mysqld

systemctl start mysqld

 

1、查看临时密码:

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
2017-03-14T01:46:42.491508Z 1 [Note] A temporary password is generated for root@localhost: Moik&g!cp5ue

2、修改密码

# mysql_secure_installation

3、允许所有外网访问

1、启动mysql

systemctl restart mysqld

2、登录mysql

mysql -u root -p 
mysql>use mysql;

3、允许所有主机访问

mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

参考链接


How to Install Latest MySQL 5.7.9 on RHEL/CentOS 7/6/5 and Fedora 23/22/21

http://www.cnblogs.com/suredandan/p/3953299.html

https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html

 

分享到:更多 ()