Announcement

Collapse
No announcement yet.

SQL Query help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #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 Dell; Thu 19 Feb '04, 3:08pm.

    Comment


    • #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...
      X