Announcement

Collapse
No announcement yet.

Cant login

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

  • Wayne Luke
    replied
    You need to select your database on the left once getting into phpMyAdmin.

    Leave a comment:


  • sudbury8
    replied
    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

    Leave a comment:


  • sudbury8
    replied
    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

    Leave a comment:


  • BirdOPrey5
    replied
    '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.

    Leave a comment:


  • sudbury8
    replied
    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

    Leave a comment:


  • BirdOPrey5
    replied
    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.

    Leave a comment:


  • sudbury8
    replied
    I found the phpmyadmin but cant find the file?

    Leave a comment:


  • BirdOPrey5
    replied
    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.

    Leave a comment:


  • sudbury8
    started a topic Cant login

    Cant login

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X