CentOS系统下以RPM方式安装mysql-5.7.19

一 下载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

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容