Completely remove MariaDB or MySQL from CentOS 7 or RHEL 7

Question

I installed MariaDB on CentOS 7 but I had some problems with some configuration  now it is completely misconfigured    Thus  I wanted to remove the MariaDB with    yum remove mariadb mariadb-server     after that I reinstalled it with    yum install mariadb mariadb-server      Unfortunately  the configuration remains  It seems as if yum remove don   t delete all MariaDB Config-Files   How can I remove MariaDB completely from CentOS 7

User · Answer

systemd  sudo systemctl stop mysqld service  amp  amp  sudo yum remove -y mariadb mariadb-server  amp  amp  sudo rm -rf  var lib mysql  etc my cnf   sysvinit  sudo service mysql stop  amp  amp  sudo apt-get remove mariadb mariadb-server  amp  amp  sudo rm -rf  var lib mysql  etc my cnf

User · Answer

These steps are working on CentOS 6 5 so they should work on CentOS 7 too    EDIT - exactly the same steps work for MariaDB 10 3 on CentOS 8    yum remove mariadb mariadb-server rm -rf  var lib mysql If your datadir in  etc my cnf points to a different directory  remove that directory instead of  var lib mysql rm  etc my cnf the file might have already been deleted at step 1 Optional step  rm    my cnf yum install mariadb mariadb-server    EDIT  - Update for MariaDB 10 1 on CentOS 7  The steps above worked for CentOS 6 5 and MariaDB 10    I ve just installed MariaDB 10 1 on CentOS 7 and some of the steps are slightly different   Step 1 would become   yum remove MariaDB-server MariaDB-client   Step 5 would become   yum install MariaDB-server MariaDB-client   The other steps remain the same

User · Answer

To update and answer the question without breaking mail servers  Later versions of CentOS 7 have MariaDB included as the base along with PostFix which relies on MariaDB  Removing using yum will also remove postfix and perl-DBD-MySQL  To get around this and keep postfix in place  first make a copy of  usr lib64 libmysqlclient so 18  which is what postfix depends on  and then use   rpm -qa   grep mariadb   then remove the mariadb packages using  changing to your versions    rpm -e --nodeps  mariadb-libs-5 5 56-2 el7 x86 64  rpm -e --nodeps  mariadb-server-5 5 56-2 el7 x86 64  rpm -e --nodeps  mariadb-5 5 56-2 el7 x86 64    Delete left over files and folders  which also removes any databases    rm -f   var log mariadb rm -f  var log mariadb mariadb log rpmsave rm -rf   var lib mysql rm -rf   usr lib64 mysql rm -rf   usr share mysql   Put back the copy of  usr lib64 libmysqlclient so 18 you made at the start and you can restart postfix   There is more detail at https   code trev id au centos-7-remove-mariadb-replace-mysql  which describes how to replace mariaDB with MySQL

[mysql] Completely remove MariaDB or MySQL from CentOS 7 or RHEL 7

Examples related to mysql

Examples related to centos

Examples related to mariadb

Examples related to yum

Examples related to rhel