CentOs7 安装卸载MySQL

MySQL安装
一、下载并安装MySQL官方的 Yum Repository

[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
[root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm
[root@localhost ~]# yum -y install mysql-community-server

二、数据库配置：
1、启动数据库

systemctl start  mysqld.service

2、查看MySQL运行状态，运行状态如图：

systemctl status mysqld.service

结果展示

[root@localhost ~]# systemctl start  mysqld.service
[root@localhost ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 六 2019-03-02 11:19:53 CST; 6min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 1317 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 998 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 1320 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─1320 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

3月 02 11:19:40 localhost.localdomain systemd[1]: Starting MySQL Server...
3月 02 11:19:53 localhost.localdomain systemd[1]: Started MySQL Server.

3、打开/etc/my.cnf配置文件，在最后一行添加 skip-grant-tables

mysql -u root -p  // 免密码登录

4、重启数据库

systemctl start  mysqld.service

4、进入mysql 环境中，输入以下命令，更改mysql 登录密码

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

5、打开 /etc/my.cnf，去掉 skip-grant-tables，再次重启数据库

systemctl start  mysqld.service

6、再次登录时，即可使用新设置的密码

MySQL 卸载
1、rpm查看安装

rpm -qa | grep -i mysql

如图所示：

2、rpm 卸载

rpm -e mysql57-community-release-el7-9.noarch
rpm -e mysql-community-server-5.7.17-1.el7.x86_64
rpm -e mysql-community-libs-5.7.17-1.el7.x86_64
rpm -e mysql-community-libs-compat-5.7.17-1.el7.x86_64
rpm -e mysql-community-common-5.7.17-1.el7.x86_64
rpm -e mysql-community-client-5.7.17-1.el7.x86_64
cd /var/lib/  
rm -rf mysql/

3、清除余项

whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/local/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
#删除上面的文件夹
rm -rf /usr/bin/mysql

4、删除配置

rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret

5、剩余配置检查

chkconfig --list | grep -i mysql
chkconfig --del mysqld

6、根据上面的列表，删除 ,如：mysqld