Cant login

[Wayne Luke]

You need to select your database on the left once getting into phpMyAdmin.

[sudbury8]

I run this UPDATE vb_user AS user
SET token = concat(MD5(concat(MD5('sudbury8'), user.token)),' ', user.token), scheme = 'legacy'
WHERE userid = 1;

error #1046 - No database selected

[sudbury8]

I put this in UPDATE vb_user AS user
SET token = concat(MD5(concat(MD5('sudbury8'), user.token)),' ', user.token), scheme = 'legacy'
WHERE userid = 1;
The above query is if vb_ is the table prefix. and got this error SQL query:
UPDATE vb_user AS user SET token = CONCAT( MD5( CONCAT( MD5( 'sudbury8' ) , user.token ) ) , ' ', user.token ) ,
scheme = 'legacy' WHERE userid =1;

MySQL said:
#1046 - No database selected

[BirdOPrey5]

'PDATE should be UPDATE you might have missed a charcter when copying... also you just gave away your password, sudbury8, so be sure you change it.

[sudbury8]

am getting this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PDATE vb_user AS user SET token = concat(MD5(concat(MD5('sudbury8'), user.token' at line 1

[BirdOPrey5]

There is no file involved.

First- make sure you have done a database backup before you try to make any edits to the database. One wrong move/typo could destroy your database so don't try to do anything without a backup.

Then go to phpmyadmin, browse to the database that has the vBulletin tables, then click on the SQL option in phpmyadmin, and paste in the query, and run it- see what it says.

If it says "1 row updated" then it worked.

[sudbury8]

I found the phpmyadmin but cant find the file?

[BirdOPrey5]

Hello,

That is a MySQL query. You need to run that in your database- for most people this will be in their phpmyadmin program. If you are unsure how to access phpmyadmin you can ask your web host where to find it.

[sudbury8]

Can some tell how to find the file to do this.Thanks
UPDATE user AS user
SET token = concat(MD5(concat(MD5('pass1234'), user.token)),' ', user.token), scheme = 'legacy'
WHERE userid = 1;

The above will reset the password of user with userid = 1 to pass1234. Change the userid if your Admin account is not userid 1.

*NOTE* - If you have a table prefix setup in your config.php file then you must put the table prefix in front of the first "user" on the first line.

Example:

UPDATE vb_user AS user
SET token = concat(MD5(concat(MD5('sudbury8'), user.token)),' ', user.token), scheme = 'legacy'
WHERE userid = 1;
The above query is if vb_ is the table prefix.

You should be able to tell easily if there is a prefix if all the table names start with the same few characters.

Once the query is run the password will now be pass1234 or whatever you set.

Set a simple password by the query and change it to a more complex one after you have logged in to reduce the chance of complications.