Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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
Distribution: PCLinuxOS2023 Fedora38 + 50+ other Linux OS, for test only.
Posts: 17,493
Rep:
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
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.
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.
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.
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?
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.
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.
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.