Lost Password/MySQL

[alexming]

If someone set up a database along time ago and can not remember the password or even the name of the database, do you know of any way of recovering this information?. I have a "root MySql Account"


Thank you

[freddydoesphp]

Log into MySQL as root and issue

mysql>show databases;

This will list all the databases. For the password, if it is encrypted your best bet is to reset it. If it is plain text just read it from the user table in the mysql database. by:

mysql>use mysql;

mysql>select * from user;

find the user in question if the password is encrypted do this.

mysql>update user set password = password('newpassword') WHERE username = 'username';