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
Detailed explanation of the relationship between Vue and VueComponent
The following case reviews the knowledge points o...
Detailed explanation of using split command to split Linux files
A few simple Linux commands let you split and rea...
Why MySQL database avoids NULL as much as possible
Many tables in MySQL contain columns that can be ...
Steps to install MySQL 5.7 in binary mode and optimize the system under Linux
This article mainly introduces the installation/st...
Solution to the problem that VC6.0 cannot be used when installed on WIN10
VC6.0 is indeed too old VC6.0 is a development to...
Detailed tutorial on installing SonarQube using Docker
Table of contents 1. Pull the image 1.1 Pull the ...
Solution to Docker image downloading too slowly
Docker image download is stuck or too slow I sear...
Linux system opens ports 3306, 8080, etc. to the outside world, detailed explanation of firewall settings
Many times, after we install a web service applic...
How to implement Linux deepin to delete redundant kernels
The previous article wrote about how to manually ...
Detailed explanation of the pitfalls of mixing npm and cnpm
Table of contents cause reason Introduction to NP...
Two methods of MySql comma concatenation string query
The following two functions are used in the same ...
ReactRouter implementation
ReactRouter implementation ReactRouter is the cor...
Solution to Nginx session loss problem
In the path of using nginx as a reverse proxy tom...
Analysis of several situations where MySQL index fails
1. Best left prefix principle - If multiple colum...
WebStorm cannot correctly identify the solution of Vue3 combined API
1 Problem Description Vue3's combined API can...