一、安装
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(下载时间较长,请耐心等候)
![](https://i-blog.csdnimg.cn/blog_migrate/04104271cd0dc8e1cd655d7fcac67643.png)
3、解压
tar -xvf mysql-5.7.15-1.el7.x86_64.rpm-bundle.tar
![](https://i-blog.csdnimg.cn/blog_migrate/76034947f24675a48d6700c5cfb9ec99.png)
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
![](https://i-blog.csdnimg.cn/blog_migrate/bec1d888e35e85c4f524694e72de470f.png)
5、配置mysql的初始化文件/etc/my.cnf
vim /etc/my.cnf
6、在my.cnf的[mysqld]代码下方添加skip-grant-tables(目的是为了首次登录时不用输入密码)
![](https://i-blog.csdnimg.cn/blog_migrate/5be38efe80a884052c8c3c7e46f26e7f.png)
7、启动mysql服务
service mysqld start
![](https://i-blog.csdnimg.cn/blog_migrate/f38f65af2bf4fb3550ae915f0d5bca8b.png)
8、验证是否启动
netstat -apln | grep mysql
![](https://i-blog.csdnimg.cn/blog_migrate/d25331763e483f1cbae87a07c2510dfb.png)
9、首次登录
mysql
![](https://i-blog.csdnimg.cn/blog_migrate/e9f8cb3fd6113cb175e4011bdc861280.png)
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
![](https://i-blog.csdnimg.cn/blog_migrate/a654ba31f04beaa4837171b66b31c831.png)
2、查询MySQL软件包
rpm -aq | grep -i mysql
![](https://i-blog.csdnimg.cn/blog_migrate/cb18aa537fc08ac0b18bf3e93a444d5d.png)
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
![](https://i-blog.csdnimg.cn/blog_migrate/1beae49c765047e7c616f72890bd3a13.png)
4、再次查询剩下有哪些mysql文件夹
find / -name "mysql"
![](https://i-blog.csdnimg.cn/blog_migrate/e87a6356e38b09c61a80e3240e64ac26.png)
5、删除这些文件夹
rm -rf /etc/selinux/targeted/active/modules/100/mysql /var/lib/mysql /var/lib/mysql/mysql /usr/share/mysql
至此MySQL删除完成