SQL Query help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • IDN
    Senior Member
    • Apr 2002
    • 4030
    • 3.5.x

    SQL Query help

    On an old VB2 board I used to manage I have forgot my password and I no longer have access to my email account. I tried eidting my email via phpMyAdmin, but it won't let me into edit my feild. What SQL query do I need to run to change the email address of my account?
    Running vB since 4-14-2002
  • Livingston Dell
    New Member
    • Dec 2003
    • 28
    • 3.0.0 Gamma

    #2
    Where X is the userid of the account you are changing...

    Code:
    UPDATE user SET email='[email protected]' WHERE userid=x
    But as you can run database queries, why not just change your password?
    Code:
    UPDATE user SET password='c4ca4238a0b923820dcc509a6f75849b' WHERE userid=x
    ... which would set your password to "1".
    Last edited by Livingston; Thu 19 Feb '04, 2:08pm.

    Comment

    • IDN
      Senior Member
      • Apr 2002
      • 4030
      • 3.5.x

      #3
      Thanks, that worked for me. I was going to change my password, but I didn't look hard enough to find a hash creator.

      Just for some reason when I go to edit my info in phpMyAdmin it gives a blank page, it won't with any other user account. I have full access to the website, I can do whatever I want if i knew how (EG: Changing my email).

      The database was actually sold because the site wasn't going too well, the site is still up and running. I changed my password to something I can't remember when the owner sold the database.
      Running vB since 4-14-2002

      Comment

      Related Topics

      Collapse

      Working...