Database password - please help

Discussion in 'Databases' started by sunny1980, Aug 25, 2009.

  1. #1
    How can I retrieve my database password. I've forgotten it and I was wondering is there a possible way to locate it?

    I have the username luckily.

    Thanks
     
    sunny1980, Aug 25, 2009 IP
  2. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Are you using a script that accesses the DB? If so, look in it's config file.
     
    premiumscripts, Aug 25, 2009 IP
  3. sunny1980

    sunny1980 Peon

    Messages:
    386
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hey,

    Erm. I have access to Cpanel. Does this help.
     
    sunny1980, Aug 25, 2009 IP
  4. superdav42

    superdav42 Active Member

    Messages:
    125
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    58
    #4
    From Cpanel the easiest thing to do would be to create a new user with a password that you won't forget and then add it to the database. Once the new user is working you can delete the one you don't know the password for.
     
    superdav42, Aug 25, 2009 IP
  5. SCLocal

    SCLocal Notable Member

    Messages:
    1,270
    Likes Received:
    58
    Best Answers:
    0
    Trophy Points:
    235
    #5
    If you have access to Cpanel you probably have access to FTP, if not set yourself up with a FTP account and use the FTP program to access all your files, in the folder for the site associated with the DB you should have a config.php file, inside that file you will have your database address, username and password.
     
    SCLocal, Aug 25, 2009 IP
  6. garychen

    garychen Peon

    Messages:
    284
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    access the database tables to replace password...
     
    garychen, Aug 25, 2009 IP
  7. yuvrajm

    yuvrajm Peon

    Messages:
    52
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    if you know the username and have access using SSH use:
    passwd <username>
    Code (markup):
    and then enter the new password
     
    yuvrajm, Sep 1, 2009 IP