Page 1 of 1

how to reinstall mysql

Posted: Thu Jul 18, 2019 6:24 pm
by 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 )

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 6:43 pm
by 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.

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 6:48 pm
by 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)

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 6:55 pm
by DirkS
NoGlow75 wrote:
Thu Jul 18, 2019 6:48 pm
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?

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 6:59 pm
by NoGlow75
yes you can i am using it rn and trying to get a lampw

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 7:12 pm
by neilgl
Have you done a quick google for “MySQL reset root password” ?
Also is the VMWare Workstation Player running on Windows or Linux?

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 9:44 pm
by 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

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 10:15 pm
by DirkS
NoGlow75 wrote:
Thu Jul 18, 2019 9:44 pm
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...

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 10:17 pm
by 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?

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 11:19 pm
by 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.

Re: how to reinstall mysql

Posted: Thu Jul 18, 2019 11:26 pm
by neilgl
Let’s hope we find out...

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 5:55 am
by fruitoftheloom
NoGlow75 wrote:
Thu Jul 18, 2019 6:48 pm
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 ????

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 7:58 am
by 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

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 9:16 am
by rpdom
NoGlow75 wrote:
Fri Jul 19, 2019 7:58 am
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.

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 9:24 am
by fruitoftheloom
NoGlow75 wrote:
Fri Jul 19, 2019 7:58 am
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...........

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 12:02 pm
by 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

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 12:27 pm
by fruitoftheloom
NoGlow75 wrote:
Fri Jul 19, 2019 12:02 pm
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 :evil: :evil:

*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

Re: how to reinstall mysql

Posted: Fri Jul 19, 2019 12:38 pm
by NoGlow75
THX sorrry i was just not happy but i am sorry ( i am about to go take a deeper Dive in Linux )

Re: how to reinstall mysql

Posted: Thu Oct 10, 2019 12:38 am
by mundaneken
fruitoftheloom wrote:
Fri Jul 19, 2019 12:27 pm
NoGlow75 wrote:
Fri Jul 19, 2019 12:02 pm
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.

Re: how to reinstall mysql

Posted: Fri Oct 11, 2019 8:02 pm
by splangie
Thanks.

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