TransWikia.com

How to clean up mysql installation on centos

Server Fault Asked on December 30, 2021

mysql does not exist anymore but when i run yum remove mysql it says that the package is available but not marked for installation, i cannot install new mysql because of that, I need to completely delete everything related to it before installing new one, i do not have tables created so don’t need to backup anything i tried to use the yum plugin yum-remove-with-leaves didn’t work and didn’t find any guide to install it properly, anyway i read on forums that it’s buggy and should not be installed so I’m searching for other ways to remove mysql completely

and can i do it using sftp?

@quanta

the output of rpm -qa | grep mysql is

mysql55-libs-5.5.10-1.w5
libmysqlclientl5-5.0.77-1.1.w5
php-mysql-5.3.8-1.1.w5

EDIT

I tried

yum remove mysql
yum remove mysql-server
yum clean all

and it doesn’t seem to fix it.

When I run yum install mysql mysql-server or yum install mysql or yum install install mysql-server i would get this

enter image description here

7 Answers

this works like a charm on centos 7 if you are inside an air-gapped (offline) server and were installed mysql using rpm bundle

service mysqld stop
rpm -qa | grep mysql | xargs -I % sh -c 'yum remove -y %'

Answered by HoseinGhanbari on December 30, 2021

rm -rf `find / -name mysql*`

This will find any files with mysql and remove them. Once that is done, you should be able to re-install mysql-server.

Answered by John Seabourn on December 30, 2021

yum remove mysql*

find / -name mysql

rm -rf (all folders listed in find)

Answered by Andre Ferreira on December 30, 2021

you may have somehow installed mariadb when you thought it was installing mysql.

[root@localhost data_decrypt]# rpm -qa | grep maria
mariadb-server-5.5.52-1.el7.x86_64
mariadb-libs-5.5.52-1.el7.x86_64
mariadb-devel-5.5.52-1.el7.x86_64
mariadb-5.5.52-1.el7.x86_64

Answered by davidj411 on December 30, 2021

  1. Execute the following command :

    # rpm -qa | grep mysql
    

    It will list all installed mysql packages on your system. Eg: mysql-libs-5.1.73-3.el6_5.x86_64

  2. now execute the command:

    # yum remove <name displayed in above step-1>
    

    Eg: yum remove mysql-libs-5.1.73-3.el6_5.x86_64

Answered by Sumedh J on December 30, 2021

yum remove mysql55-libs and try again.

Besides, I saw you used a lot of repos: atomic, dag, epel, rpmforge, livna, ..., it may be the cause of conflicting. In my opinion, atomic and (rpmforge or epel) are enough.

Answered by quanta on December 30, 2021

Try this:

    yum clean all
    yum install mysql

Answered by Richardp on December 30, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP