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?
SQL Query help
Collapse
X
-
Where X is the userid of the account you are changing...
Code:UPDATE user SET email='[email protected]' WHERE userid=x
Code:UPDATE user SET password='c4ca4238a0b923820dcc509a6f75849b' WHERE userid=x
Last edited by Livingston; Thu 19 Feb '04, 2:08pm. -
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-2002Comment
Related Topics
Collapse
-
by Pilgrim23I have a vBulletin Forum that is on 123 reg VPS
The person who originally set it up for me set himself up as the admin.
I have been abroad a while with the military and only just come back...7 Photos-
Channel: Support Issues & Questions
Tue 12 May '15, 7:55am -
-
by fishingforumHi
I upgraded my site to 5.1 .
I switched the forum off whilst doing this and now it asking me to log back in and being blonde ive forgotten it and as the forum is switched of...-
Channel: Support Issues & Questions
Tue 25 Mar '14, 1:12am -
Comment