SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    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

  2. #2
    Dumb PHP codin' cat
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •