Can't able to install mysql again

Since Zorin 16 is based on Ubuntu 20.04, I think you should follow this guide:

1 Like

i followed 1st step ,
after that
in 2nd step my terminal say different

milesdredd@milesdredd-hp-notebook:~$ sudo mysql_secure_installation
[sudo] password for milesdredd:

Securing the MySQL server deployment.

Enter password for user root:
Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
milesdredd@milesdredd-hp-notebook:~$

, i also tried this error on google but that also didn't worked

Did you try installing it in Synaptic?
When you are not so sure about dependency, it is much clear to install apps in Synaptic than command line. My husband is using Synaptic all the time.

Have you tried

sudo dpkg --configure -a

If that fails,
try

dpkg -l|grep mysql-server

to find the Version of mysql you are using. Above it says 8..0, but if your result from dpkg -l above is different, repalce 8.0 with that:

sudo apt-get install mysql-server-8.0 --reinstall

sudo dpkg-reconfigure mysql-server-8.0

1 Like

i got this internal error...

FrenchPress's suggestion of using Synaptic to remove and reinstall or repair broken packages is a good one. Have you used Synaptic before?

no , i didn;t used it yet

pls help , how can i do that?

To install Synaptic

sudo apt install synaptic

Then you can open Synaptic from your app menu. You will be prompted for a password since Synaptic must access Root. Once open, look at the Vertical Left Pane- toward the bottom are buttons;
Sections
Status
Origin...
Click on Custom Filters. On the Upper portion of the Side Pane, you will see
All
Broken...
Click on Broken.
If you have broken packages, you will see them listed- Right Click on the package to select your option.

Otherwise:
Open Synaptic, then click the Search Button on the Top Toolbar. Type in mysql.
It will list your mysql packages and show whether they are Installed, Broken, etc. You can right click for options such as "Remove Completely."
You must then hit the Apply button on the top toolbar.
If able to remove them, you can search again for mysql and then select the mysql packages with a right Click and choose install.
You must then hit the Apply button on the top toolbar.

The Package list on Synaptic can be confusing when you first start using it. I remember the first time I used Synaptic, I was so bewildered, I almost never used it again. But it is easy to learn- feel free to post screenshots of what packages are listed if you would like to confirm your steps as you go.

1 Like

Did you also remove the old installation before the re-installation?

1 Like

yes , perfectly ,

just now i removed mysql , again followed by ur link

hope it will work

one more thing is that , whenever i m removing mysql,
it also removes system settings

only tweak is present

here i have to do :
sudo apt install --reinstall zorin-os-desktop

2 Likes

Annoying, isn't it!? You're not the only one that experiences that. Since inter-dependencies apply, this happens to everyone that installs mysql. it can be a bit of a shock.

2 Likes

I wanted to keep my main machine as simple as possible. My solution was to setup Raspberry Pi server and install mySQL on it.

i dont understand this properly,
for doing this i have to buy a Raspberry pi?
and to open mysql , everytime i have to reboot my pc ??

It is not mandatory to use Raspberry pi to setup a server. You can install it on any system that can run Linux.

But for energy consumption, it is way more economical to use single board computers such as RasPi since the server has to be on 24 hours a day.

I have installed MXLinux for RasPi4 + LAMP stack and using it as a WordPress server.

I access to this server with VNC, ssh or web interface (phpMyAdmin).

but i want to install mysql so that i can use while online class , so if i m going to install new os , means i have to install browser , and google meet setup n all , even i hv duall booted this , i don't want to go on windows 10 side to use mysql

I am bit lost. I do not have Windows on this main machine and never need Windows to access the server.

1 Like


i dont hv any broken package,

yes , i typed mysql on search box so i got tooo many files , i don't think i hv to remove those pls see:-


i will be in problem after deleting all these files :joy: :sweat_smile:
how to remove if any mysql file is there ,

To compare, I also took a screenshot of Synaptic in my WP server:

There could be some differences since MXLinux is Debian base, not Ubuntu base.

1 Like

And this is a screenshot of Synaptic in main machine which has no mySQL. Curiously, there are some mySQL files installed already without me doing anything.