Announcement

Collapse
No announcement yet.

Cant login

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

  • 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.
    www.untwistedvoice.com

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

    Comment


    • #3
      I found the phpmyadmin but cant find the file?
      www.untwistedvoice.com

      Comment


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

        Comment


        • #5
          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
          www.untwistedvoice.com

          Comment


          • #6
            '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.

            Comment


            • #7
              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
              www.untwistedvoice.com

              Comment


              • #8
                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
                www.untwistedvoice.com

                Comment


                • #9
                  You need to select your database on the left once getting into phpMyAdmin.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud customization and demonstration site.
                  vBulletin 5 Documentation - Updated every Friday. Report issues here.
                  vBulletin 5 API - Full / Mobile
                  I am not currently available for vB Messenger Chats.

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X