Uninstalling MySQL database under Linux
|
How to uninstall MySQL database under Linux? The following summarizes and organizes the methods of uninstalling MySQL on the Linux platform. There are three main ways to install MySQL: binary package installation (Using Generic Binaries), RPM package installation, and source code installation. The uninstallation steps are slightly different depending on the installation method. If there are any deficiencies or errors in the article, please point them out or add to them! Uninstalling MySQL using RPM package installation 1. Check whether the MySQL component is installed. [root@DB-Server init.d]# rpm -qa | grep -i mysql MySQL-devel-5.6.23-1.linux_glibc2.5 MySQL-client-5.6.23-1.linux_glibc2.5 MySQL-server-5.6.23-1.linux_glibc2.5
As shown above, the client, server, and devel components of MySQL 5.6.23 are installed. 2. Close the MySQL service before uninstalling 2.1 Method 1 [root@DB-Server init.d]# service mysql status MySQL running (25673) [ OK ] [root@DB-Server init.d]# service mysql stop Shutting down MySQL..[ OK ] [root@DB-Server init.d]# service mysql status MySQL is not running [FAILED]
2.2 Method 2 [root@DB-Server init.d]# ./mysql status MySQL running (26215) [ OK ] [root@DB-Server init.d]# ./mysql stop Shutting down MySQL..[ OK ] [root@DB-Server init.d]# ./mysql status MySQL is not running [FAILED] [root@DB-Server init.d]#
[root@DB-Server init.d]# chkconfig --list | grep -i mysql mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@DB-Server init.d]# 3. Collect the folder information corresponding to MySQL [root@DB-Server init.d]# whereis mysql mysql: /usr/bin/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz It is best to use the find command to view files related to the MySQL database, so that you can completely delete MySQL later. [root@DB-Server init.d]# find / -name mysql /etc/rc.d/init.d/mysql /etc/logrotate.d/mysql /var/lock/subsys/mysql /var/lib/mysql /var/lib/mysql/mysql /usr/include/mysql /usr/include/mysql/mysql /usr/bin/mysql /usr/share/mysql /usr/lib64/mysql
4. Uninstall and delete various MySQL components [root@DB-Server init.d]# [root@DB-Server init.d]# rpm -ev MySQL-devel-5.6.23-1.linux_glibc2.5 [root@DB-Server init.d]# rpm -ev MySQL-server-5.6.23-1.linux_glibc2.5 You have new mail in /var/spool/mail/root [root@DB-Server init.d]# rpm -ev MySQL-client-5.6.23-1.linux_glibc2.5 [root@DB-Server init.d]#
5. Delete the folder corresponding to MySQL Check whether each MySQL folder has been cleaned up and deleted. [root@DB-Server init.d]# whereis mysql mysql: [root@DB-Server init.d]# find / -name mysql /var/lib/mysql /var/lib/mysql/mysql /usr/lib64/mysql [root@DB-Server init.d]# rm -rf /var/lib/mysql [root@DB-Server init.d]# rm -rf /var/lib/mysql/mysql [root@DB-Server init.d]# rm -rf /usr/lib64/mysql [root@DB-Server init.d]# 6. Delete mysql users and user groups If necessary, delete the mysql user and the mysql group. [root@DB-Server ~]# more /etc/passwd | grep mysql mysql:x:101:501::/home/mysql:/bin/bash [root@DB-Server ~]# more /etc/shadow | grep mysql mysql:!!:16496:::::: [root@DB-Server ~]# more /etc/group | grep mysql mysql:x:501: [root@DB-Server ~]# userdel mysql [root@DB-Server ~]# groupdel mysql groupdel: group mysql does not exist [root@DB-Server ~]# 7. Confirm whether MySQL is uninstalled or deleted [root@DB-Server init.d]# rpm -qa | grep -i mysql Uninstalling MySQL using binary package or source code installation If you installed MySQL using a binary package, you will not find any MySQL components using the following command. So if you don't know how to install MySQL, don't use the following command to determine whether MySQL is installed. [root@DB-Server init.d]# rpm -qa | grep -i mysql 1. Check the MySQL service and shut down the service process. First, check the status of the MySQL service through the process. As shown below, the MySQL service is started. [root@DB-Server init.d]# ps -ef | grep mysql root 4752 4302 0 22:55 pts/1 00:00:00 more /etc/init.d/mysql.server root 7176 1 0 23:23 pts/1 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/DB-Server.localdomain.pid mysql 7269 7176 15 23:23 pts/1 00:00:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/DB-Server.localdomain.err --pid-file=/usr/local/mysql/data/DB-Server.localdomain.pid root 7321 4302 0 23:23 pts/1 00:00:00 grep mysql [root@DB-Server init.d]# /etc/init.d/mysql.server status MySQL running (7269) [ OK ] [root@DB-Server init.d]# /etc/init.d/mysql.server stop Shutting down MySQL..[ OK ] [root@DB-Server init.d]# /etc/init.d/mysql.server status MySQL is not running [FAILED] [root@DB-Server init.d]#
2. Find the installation directory of MySQL and delete it completely [root@DB-Server init.d]# whereis mysql mysql: /usr/local/mysql [root@DB-Server init.d]# find / -name mysql /var/spool/mail/mysql /usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/include/mysql /usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/bin/mysql /usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/data/mysql /usr/local/mysql
[root@DB-Server init.d]# rm -rf /usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/ [root@DB-Server init.d]# rm -rf /usr/local/ [root@DB-Server init.d]# rm -rf /var/spool/mail/mysql [root@DB-Server init.d]# 3. Delete some configuration files. The configuration files are generally /etc/my.cnf or /etc/init.d/mysql.server, depending on the specific installation configuration. 4. Delete MySQL users and user groups [root@DB-Server ~]# id mysql uid=101(mysql) gid=501(mysql) groups=501(mysql) context=root:system_r:unconfined_t:SystemLow-SystemHigh [root@DB-Server ~]# userdel mysql Reference: Detailed explanation of completely uninstalling MySQL under Linux The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: How to modify the time in centos virtual machine
>>: Vue implements countdown function
Recommend
MySql multi-condition query statement with OR keyword
The previous article introduced the MySql multi-c...
My personal summary of mysql 5.7 database installation steps
1.mysql-5.7.19-winx64.zip (this is the free insta...
Vue.js implements music player
This article shares the specific code of Vue.js t...
Detailed tutorial on how to compile and install mysql8.0.29 in CentOS8 deployment LNMP environment
1. Prerequisites Since I have installed it severa...
Introduction to installing and configuring JDK under CentOS system
Table of contents Preface Check and uninstall Ope...
Solution for Vue routing this.route.push jump page not refreshing
Vue routing this.route.push jump page does not re...
A detailed introduction to wget command in Linux
Table of contents First install wget View Help Ma...
Tips for adding favicon to a website: a small icon in front of the URL
The so-called favicon, which is the abbreviation o...
Solution to the problem that Docker cannot stop or delete container services
Preface Today, a developer gave me feedback that ...
Unbind SSH key pairs from one or more Linux instances
DetachKeyPair Unbind SSH key pairs from one or mo...
Don't forget to close the HTML tag
Building web pages that comply with Web standards ...
MySQL 5.7.17 installation and configuration method graphic tutorial (Ubuntu 16.04)
Download the latest version of MySQL for Ubuntu L...
FastDFS and Nginx integration to achieve code analysis
FastDFS & Nginx Integration: The tracker is c...
Installation of Docker CE on Ubuntu
This article is used to record the installation o...
Detailed examples of Zabbix remote command execution
Table of contents one. environment two. Precautio...