SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Lost Password/MySQL
-
Feb 25, 2001, 20:30 #1
- Join Date
- Aug 2000
- Posts
- 248
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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
-
Feb 25, 2001, 20:36 #2
- Join Date
- Aug 2000
- Location
- San Diego, CA
- Posts
- 5,460
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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';Please don't PM me with questions.
Use the forums, that is what they are here for.
Bookmarks