Change Vbulletin forums Admin Password through database directly

 

As a developer you may require to change the admin password . There are two ways to change password of vbulletin admin section.

  1. By using forget password feature in which you will receive new password on admin’s email.
  2. By updating new admin password from database directly.>> Admin’s password is stored into user table of vbulletin but password is stored into hashes (encryption strategy)>> Mostly admin user uses “usergroup” field value 6. So you need to identify the admin user.

 

Now you simply need to update passwords value to that user. To update new password you simply run the below SQL query.

 

UPDATE user
set password = MD5(concat(MD5(‘newpassword’), user.salt))
WHERE userid = 1 ”

 

Related posts:

The following two tabs change content below.

Chandra Shekhar

GCP Architect
Chandra Shekhar Pandey is Google certified Cloud engineer, I am Magento2 Trained developer. Having huge experience in designing cloud solution. I have around 12 years of experience with world enterprise IT companies and fortune 500 clients. During my architecture design I am always caring about high availability, fast performance and resilient system. From the programmer background I have huge experience in LAMP stack as well. Throughout my carrier I have worked on Retail, E-Learning, Video... Read More about Chandra Shekhar

Latest posts by Chandra Shekhar (see all)