My local host database has vanished
Posted by: Pisco (
Date: June 26, 2021 11:56PM


I updated MaraDB and as a rule of thumb, I normally back up my local host site database first. This time though, when I tried to do so by exporting the data base from phpmyadmin the database wasn't there. Because is a local host my phpmyadmins has no passport. Unfortunately I forgot my username and I tried with one word that allow me to get in but it could be one for another empty local host site I have.
How can I recover a forgotten username of my local web?
Hoe can I find out where the DB is located?
Apparently I still can access but I am worried than if I update anything in the future and I don't back it up, I may run into some big problems.

Thanks for your attention,

Options: ReplyQuote
Re: My local host database has vanished
Posted by: Otomatic (Moderator)
Date: June 27, 2021 10:08AM


You go back to the previous version of MariaDB and you will find your database.

The default user name for both MariaDB and MySQL has always been root with no password.

Wampserver 3.2.7 32 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.7 64 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36/8.0.27 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote

Sorry, only registered users may post in this forum.