how to reinstall mysql

[NoGlow75]

wen i was installling wordpress i found out i cant do anything with mysql and that i need to reinstall it

but how do i do that ?? i got really zero info about how to to it
.
Do someone know how to Reinstall it ?? ( I lost the password of it )

[Andyroo]

Between this issue, the ApacheGUI and your SSH issues I would start with a new image and give up on this server - I feel that it will take more time to sort out than start afresh.

[NoGlow75]

i was in the mode of doin that but >... even the network driver is not working( my raspberry is from 2016 )
i want to reinstall the holl ip but apache2 fail2ban is not really working with my ) ( and i did a custom DNS setup )

i have installed i n vmware so i allways can go back (snapshots)

[DirkS]

i have installed i n vmware so i allways can go back (snapshots)

Can you run Raspberry Pi / armhf software in a VMware virtual machine?

[NoGlow75]

yes you can i am using it rn and trying to get a lampw

[neilgl]

Have you done a quick google for “MySQL reset root password” ?
Also is the VMWare Workstation Player running on Windows or Linux?

[NoGlow75]

no I did more but is Now not even working ( i think the PI is just old ( even apt-get update is not working ) sudo is not a command any more ??
and apache2 open ssh and Fail2bana re not runnig any more

[DirkS]

no I did more but is Now not even working ( i think the PI is just old ( even apt-get update is not working ) sudo is not a command any more ??
and apache2 open ssh and Fail2bana re not runnig any more

Your Pi is probably fine, but your root file system is corrupt...

[neilgl]

Sorry, I thought you were running Raspbian in a VM under VMWare, with various snapshots.
So can you restore an older snapshot that works?
Also is your network connection to the pi working?

[Andyroo]

This just gets odder and odder...

VM Pi or old physical, odd errors, wonder if someone is trying to crack a box or troll.

I do not think I can add anything else.

[neilgl]

Let’s hope we find out...

[fruitoftheloom]

i was in the mode of doin that but >... even the network driver is not working( my raspberry is from 2016 )
i want to reinstall the holl ip but apache2 fail2ban is not really working with my ) ( and i did a custom DNS setup )

i have installed i n vmware so i allways can go back (snapshots)

VMWare does not support emulating the ARM CPU of the Raspberry Pi..

...so what Operating System are you actually running ????

[NoGlow75]

Uhhh I intaled on vm _ like just go to raspbarry and download the desktop os and set the setting to 8 cores and 4 gb ram dan 30 gb Hdd and set is in deabin8.0/64 bit

[rpdom]

Uhhh I intaled on vm _ like just go to raspbarry and download the desktop os and set the setting to 8 cores and 4 gb ram dan 30 gb Hdd and set is in deabin8.0/64 bit

That would be interesting as the Raspberry Pi 4B only has 4 cores.
Also it runs Raspbian which is based on Debian 10.0/32 bit.

[fruitoftheloom]

Uhhh I intaled on vm _ like just go to raspbarry and download the desktop os and set the setting to 8 cores and 4 gb ram dan 30 gb Hdd and set is in deabin8.0/64 bit

If you downloaded Debian with Raspberry Pi Desktop (32bit Userland with Architecture specific kernel) it is not Raspbian or related to Operating Systems running on Raspberry Pi SBC.

Totally and utterly confused...........

[NoGlow75]

on my raspberry Pi with "Raspbian Buster Lite It" it dont want go install ??

Code: Select all

sudo apt-get install mysql-server php-mysql -y

Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  mariadb-server-10.0 ( dont work to ) 

Code: Select all

E: Package 'mysql-server' has no installation candidate

[fruitoftheloom]

i reinstalled the raspberry ( Fun fact Myqsl not wanna work ) ( On my Linux server debain it works ) ( installing in Vm what runs Desktop version It works )

on my raspberry Pi with "Raspbian Buster Lite It" it dont want go install ??

sudo apt-get install mysql-server php-mysql -y


Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
mariadb-server-10.0 ( dont work to )

E: Package 'mysql-server' has no installation candidate

( the system is full up-to-date and runs Release date:2019-07-10 of
Raspbian Buster Lite)
i Tried more but i think i use the wrong command to install it

i just hate mysql

*sensored*

Please stick to facts, we are not interested in other hardware / software it is just confusing the issue, swearing is also not needed, children read this forum.


Regards you issue, running Raspbian Buster on your Raspberry Pi:

Code: Select all

sudo apt update
sudo apt install mariadb-server-10.3 php-mysql
sudo reboot

[NoGlow75]

THX sorrry i was just not happy but i am sorry ( i am about to go take a deeper Dive in Linux )

[mundaneken]

i reinstalled the raspberry ( Fun fact Myqsl not wanna work ) ( On my Linux server debain it works ) ( installing in Vm what runs Desktop version It works )

on my raspberry Pi with "Raspbian Buster Lite It" it dont want go install ??

sudo apt-get install mysql-server php-mysql -y

...
Regards you issue, running Raspbian Buster on your Raspberry Pi:

Code: Select all

sudo apt update
sudo apt install mariadb-server-10.3 php-mysql
sudo reboot

Perfect.

And mysql is a wonderful package once you get to know it. Served me well for many years. Try setting-up Oracle and dealing with its hideous schemas and crap if you want a real frustrating database experience.

[splangie]

Thanks.

Using mariadb-server-10.3 instead of mysql.server worked for me.