MySQL admin user account somehow got blown away

Submitted by sespit on Mon, 07/25/2016 - 11:25

Somehow the default MySQL admin account, which I believe was prepopulated by the installer, got blown away while I was deleting a Virtualhost. Fortunately I was able to reset things following these instructions: https://www.howtoforge.com/reset-forgotten-mysql-root-password

Is it possible I forgot to note the MySQL daemon credentials when I initially installed Virtualmin Pro? If so, is there anyway to recover them? I also have PostgreSQL running but like MySQL, I don't know the default credentials.

Status: 
Active

Comments

Submitted by andreychek on Mon, 07/25/2016 - 11:46

Howdy -- the Virtualmin installer doesn't create the database root user, though during the initial setup it does ask what password to set for those.

Did someone else perhaps set those up? If so, they may recall what they were set to.

Other than that, if you're currently unable to connect to Postgres as the admin user, you may need to reset the password using something like this here:

http://stackoverflow.com/questions/10845998/i-forgot-the-password-i-ente...

Submitted by sespit on Mon, 07/25/2016 - 15:49

So Postgre is fine, it's MySQL that is broken. Is there anyway to recover the MySQL credentials?