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
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.
Did you also remove the old installation before the re-installation?
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
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.
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.
yes , i typed mysql on search box so i got tooo many files , i don't think i hv to remove those pls see:-
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.
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.
hmm, now without removing anything ,
also i have removed mysql files
as this above link said ,
i m going to install mysql again , hope it will be ok
