Linux CentOs7用rpm的方式安装和卸载mysql

一、安装

1、创建目录并进入

mkdir /opt/mysql5.7 && cd /opt/mysql5.7

2、下载mysql5.7.15版本

wget https://downloads.mysql.com/archives/get/file/mysql-5.7.15-1.el7.x86_64.rpm-bundle.tar（下载时间较长，请耐心等候）

3、解压

tar -xvf mysql-5.7.15-1.el7.x86_64.rpm-bundle.tar

4、安装（必须依次安装，因为他们之间存在依赖链）

rpm -ivh mysql-community-common-5.7.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.15-1.el7.x86_64.rpm

5、配置mysql的初始化文件/etc/my.cnf

vim /etc/my.cnf

6、在my.cnf的[mysqld]代码下方添加skip-grant-tables（目的是为了首次登录时不用输入密码）

7、启动mysql服务

service mysqld start

8、验证是否启动

netstat -apln | grep mysql

9、首次登录

mysql

10、设置root密码

update mysql.user set authentication_string = password('123456'),host='%' where user = 'root';

flush privileges;

 

至此，完成rpm包安装mysql

 

二、解决安装时的报错

1、在第四步执行rpm-ivh mysql-community-common-5.7.15-1.el7.x86_64.rpm的时候报错

警告：mysql-community-common-5.7.15-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
    file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.15-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86
_64    file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.15-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x8
6_64    file /usr/share/mysql/dutch/errmsg.sys from install of mysql-community-common-5.7.15-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86
_64    file /usr/share/mysql/english/errmsg.sys from install of mysql-community-common-5.7.15-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x
86_64

原因：已存在mariadb-libs-1:5.5.60-1.el7_5.x86_64的库（这是linux自带的）所以需要先删除以前的库才能安装！

解决方法：

①、先查询时候安装了mariadb

②、卸载mariadb

三、卸载

1、关闭mysql服务

service mysqld stop

2、查询MySQL软件包

rpm -aq | grep -i  mysql

3、依次卸载系统下的所有mysql软件包

rpm -ev mysql-community-server-5.7.15-1.el7.x86_64
rpm -ev mysql-community-client-5.7.15-1.el7.x86_64
rpm -ev mysql-community-libs-5.7.15-1.el7.x86_64 --nodeps（忽略依赖 --nodeps）
rpm -ev mysql-community-common-5.7.15-1.el7.x86_64

4、再次查询剩下有哪些mysql文件夹

 find / -name "mysql"

5、删除这些文件夹

rm -rf /etc/selinux/targeted/active/modules/100/mysql /var/lib/mysql /var/lib/mysql/mysql /usr/share/mysql

 

至此MySQL删除完成