[SOLVED] Trouble uninstalling MySql

AlexBB · 04-25-2015, 04:25 PM

Hi there,

My environment is Ubuntu 14.04. I have this problem. I have MySql installed but it is a previous version:

Code:

alex@alex-....:~/GFORTRAN-APPS/SPHERE-DESIGN$ mysql --version
mysql  Ver 14.14 Distrib 5.5.41, for debian-linux-gnu (i686) using readline 6.3

In order to install a newer version (5.6.24) I found in Oracle website I have to remove the previous version: 5.5.41. This is what I get when I try:

Code:

alex@alex-.....~/GFORTRAN-APPS/SPHERE-DESIGN$ sudo apt-get purge mySql
Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package mySql

I also used:

Code:

sudo apt-get remove mySql

with the same result

Any clue?

Thanks, - Alex

knudfl · 04-25-2015, 07:50 PM

sudo apt-get remove mySql : 'apt-get' doesn't accept spell errors.
And there is no package by name mySql.
Also : No upper case in any Ubuntu package names ...
http://packages.ubuntu.com/search?ke...searchon=names

You can check what you have installed with :
$ dpkg --get-selections | grep mysql

-

AlexBB · 04-26-2015, 10:25 AM

knudfl, thanks. Here is the response:

Code:

dpkg --get-selections | grep mysql 
libdbd-mysql-perl				install
libmysqlclient18:i386				install
mysql-client-5.5				install
mysql-client-core-5.5				install
mysql-common					install
mysql-server					install
mysql-server-5.5				install
mysql-server-core-5.5				install

What do you mean by "spell errors?" Where is the spelling error?

I want to install Oracle's MySql. First I want to remove what I have installed a couple of months ago.

What shall I do next?

- Alex

AlexBB · 04-26-2015, 10:38 AM

OK, I used "misspelled" :-) sudo apt-get command to remove the packages one by one successfully, I think. Then I ran your command again:

Code:

dpkg --get-selections | grep mysql 
libmysqlclient18:i386				deinstall
mysql-common					deinstall
mysql-server-5.5				deinstall

What does it mean?

Thanks, - Alex

pan64 · 04-26-2015, 10:50 AM

probably this helps: https://lists.debian.org/debian-user.../msg01027.html

AlexBB · 04-26-2015, 10:54 AM

OK, I used the same command with "purge" instead of "remove for those three packages." It seemed to work:

Code:

sudo apt-get purge libmysqlclient18:i386
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  libmysqlclient18*
0 upgraded, 0 newly installed, 1 to remove and 91 not upgraded.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
(Reading database ... 197122 files and directories currently installed.)
Removing libmysqlclient18:i386 (5.5.41-0ubuntu0.14.04.1) ...
Purging configuration files for libmysqlclient18:i386 (5.5.41-0ubuntu0.14.04.1) ...
alex@alex-....~/GFORTRAN-APPS/SPHERE-DESIGN$ sudo apt-get purge mysql-common
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  mysql-common*
0 upgraded, 0 newly installed, 1 to remove and 91 not upgraded.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
(Reading database ... 197122 files and directories currently installed.)
Removing mysql-common (5.5.41-0ubuntu0.14.04.1) ...
Purging configuration files for mysql-common (5.5.41-0ubuntu0.14.04.1) ...
alex@alex-....~/GFORTRAN-APPS/SPHERE-DESIGN$ sudo apt-get purge mysql-server-5.5
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  mysql-server-5.5*
0 upgraded, 0 newly installed, 1 to remove and 91 not upgraded.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
(Reading database ... 197120 files and directories currently installed.)
Removing mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) ...
Purging configuration files for mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) ...
dpkg: warning: while removing mysql-server-5.5, directory '/etc/mysql' not empty so not removed

Now, at the end of the three purges a window showed up asking if I wanted to remove the directory /var/lib/mysql. It had two options: Yes and No but the No was the default and there was no way to switch from No to Yes because the No option was frozen. I wanted to remove ALL mySql related directories. Somehow I closed that window and then I got the final message that the directories were not removed.

What shall I do now to remove those directories?

Thanks, - ALex

AlexBB · 04-26-2015, 11:04 AM

I just went to /var/lib/mysql. It is a real sucker. I cannot remove it, I cannot get inside to see what is there. It seems the only way to do something about it is to reinstall the Ubuntu.

Is there any way to removed this garbage?

- Alex

pan64 · 04-26-2015, 01:00 PM

If there was no other way just boot into single user mode and remove /var/lib/mysql. But I think that is not the perfect solution. You can check (with lsof) what uses that directory.

AlexBB · 04-26-2015, 02:01 PM

I tried this as you suggested:

Code:

lsof > t1

The result was 32,655 lines. There was no MySql in there but plenty of SqlLite. What is this? Is it a database management system? Perhaps this is what I need. Linux has EVERYTHING!!!

I need a database to store intermediate results of massive numerical computations.

But I still want to remove that folder with MySql.

***How can I boot into a single user?*** And why is it not a perfect solution?

Thanks, - Alex

AlexBB · 05-03-2015, 10:22 AM

I still cannot delete MySql directory. I tried various options offered here and nothing worked. Pan64, a Hungarian guru dropped a "suggestion" but then disappeared and refused to answer my simple question. Before I reinstalled the Ubuntu to get rid of the sucker, I want to bring this question to your attention again. It seems to be a problem affecting other people as well.

Thanks, - Alex

pan64 · 05-03-2015, 10:53 AM

disappeared? refused? just search the net on that issue, and you will find a lot of different solutions, like this:
http://askubuntu.com/questions/13296...mode-from-grub

sqlite is another database engine. And actually that is the answer, if sqlite uses that directory you need that. Not all of it, but a file or dir inside.

AlexBB · 05-03-2015, 11:55 AM

Thank you Pan64. In order to install SqlLite I need to get rid of MySql. Thanks for the pointer. I agree, I should have googled it myself.

Quote:

And actually that is the answer, if sqlite uses that directory you need that. Not all of it, but a file or dir inside.

I am very suspicious of that directory. Why is it so protected? I am quite familiar with Microsoft Sql Server (it runs on another machine of mine) and would like to have a database and the management system somewhat similar to it. That is why I began looking into MySql.

Thank you for your help. - Alex

P.S. Pan obviously stands for Pannonia, a code message :-) Lol.

AlexBB · 05-03-2015, 12:09 PM

When I installed MySql that website offered me to "configure" the database by Percona Configuration Wizard. I now regret that I agreed. I think they installed that folder/directory and I am paranoid that they "monitor" my computer :-). I want to get rid of the folder and download Oracle MySql.

Thanks, - Alex

AlexBB · 05-03-2015, 03:00 PM

Pan64, I've installed Grub, now I would appreciate instructions what to do next. Thanks, - Alex

jkirchner · 05-03-2015, 03:47 PM

Seems to be some good advice here: how-do-i-uninstall-mysql from AskUbuntu