一 下载mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar
[root@localhost mysql-community]# tar -xvf mysql-5.7.19-1.el7.x86_64.rpm-bundle.tar
mysql-community-embedded-devel-5.7.19-1.el7.x86_64.rpm
mysql-community-client-5.7.19-1.el7.x86_64.rpm
mysql-community-server-5.7.19-1.el7.x86_64.rpm
mysql-community-test-5.7.19-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.19-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.19-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.19-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm
mysql-community-common-5.7.19-1.el7.x86_64.rpm
mysql-community-embedded-5.7.19-1.el7.x86_64.rpm
mysql-community-devel-5.7.19-1.el7.x86_64.rpm
mysql-community-libs-5.7.19-1.el7.x86_64.rpm
二 准备安装
[root@localhost mysql-community]# rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql-community-client(x86-64) >= 5.7.9 is needed by mysql-community-server-5.7.19-1.el7.x86_64
mysql-community-common(x86-64) = 5.7.19-1.el7 is needed by mysql-community-server-5.7.19-1.el7.x86_64
mariadb-server is obsoleted by mysql-community-server-5.7.19-1.el7.x86_64
安装时候会提示与已经安装的RPM包有冲突,所以我们先卸载一些RPM包,要卸载哪些呢?我们要卸载的是包含有mariadb关键字的RPM包,执行命令:rpm -qa|grep mariadb来查看一下我们要卸载哪些软件:
[root@localhost mysql-community]# rpm -qa|grep mariadb
mariadb-devel-5.5.52-1.el7.x86_64
mariadb-5.5.52-1.el7.x86_64
mariadb-libs-5.5.52-1.el7.x86_64
mariadb-server-5.5.52-1.el7.x86_64
卸载mariadb:
[root@localhost mysql-community]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
[root@localhost mysql-community]# rpm -e --nodeps mariadb-server-5.5.52-1.el7.x86_64
[root@localhost mysql-community]# rpm -e --nodeps mariadb-5.5.52-1.el7.x86_64
[root@localhost mysql-community]# rpm -e --nodeps mariadb-devel-5.5.52-1.el7.x86_64
[root@localhost mysql-community]# rpm -qa|grep mariadb
三 安装
按以下顺序安装MySQL
[root@localhost mysql-community]# rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-5.7.19-1.e################################# [100%]
[root@localhost mysql-community]# rpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-libs-5.7.19-1.el7################################# [100%]
[root@localhost mysql-community]# rpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-client-5.7.19-1.e################################# [100%]
[root@localhost mysql-community]# rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-server-5.7.19-1.e################################# [100%]
[root@localhost mysql-community]#
四 测试
mysql配置文件为/etc/my.cnf
修改编码配置:
[mysql]
default-character-set =utf8
service mysqld restart
mysql> set password for 'root'@'localhost' =password('password');
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on . to root@'%'identified by 'password';
参考:
http://www.cnblogs.com/starof/p/4680083.html
http://jingyan.baidu.com/article/93f9803f010d8fe0e56f555e.html