Facebook Twitter Instagram
    TecAdmin
    • Home
    • Ubuntu 20.04
      • Upgrade Ubuntu
      • Install Java
      • Install Node.js
      • Install Docker
      • Install LAMP Stack
    • Tutorials
      • AWS
      • Shell Scripting
      • Docker
      • Git
      • MongoDB
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    Home»General Articles»Reset Joomla Admin Password via SQL or phpMyAdmin

    Reset Joomla Admin Password via SQL or phpMyAdmin

    RahulBy RahulDecember 2, 20172 Mins ReadUpdated:December 7, 2017

    Question – How to reset Joomla admin password via SQL query? How to reset Joomla admin password using phpMyAdmin? How to Reset Joomla forgotten password with SQL query? How to find Joomla default admin password?

    If you have forgotten your Joomla admin password or due to any reason, you are not able to login to Joomla with admin user. You can simply check the active admin user using SQL query and reset the password with simple SQL query. After updating password with any of below method your Joomla administrator user password will be secret.

    Reset Joomla Admin Password via SQL

    First, find the ID for of the Joomla administrator account using the following command. Change table prefix im4p8_ with your table prefix of Joomla database.

    1
    SELECT * FROM im4p8_users;

    If you only have the ID of the admin user account. Update the admin password using the below query. Your Joomla admin password will be secret. You can change it latest from Admin dashboard.

    1
    UPDATE im4p8_users set password = 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199' WHERE ID = 888;

    Reset Joomla Admin Password via phpMyAdmin

    You can also connect Joomla database with phpMyAdmin and reset the admin password. Open table *_users and edit the record of the admin user. Now under the password column insert the string “d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199” and save the record by clicking Go button. You password will be secret. You can change it latest from Admin dashboard.

    Reset Joomla Admin Password

    You can install phpMyAdmin using this tutorial.

    admin Joomla password
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp
    Previous ArticleHow to Install Joomla 3.9 CMS on Ubuntu, Debian, LinuxMint
    Next Article How to Install Swift on Ubuntu 16.04 LTS

    Related Posts

    How to Import GPG Keys on Ubuntu & Debian (without apt-key)

    2 Mins Read

    Running a Cron job every Sunday (Weekly)

    2 Mins Read

    Scheduling a Python Script with Crontab

    2 Mins Read

    Running cron job every 12 hours (twice a day)

    Updated:August 2, 20221 Min Read

    (Resolved) Key is stored in legacy trusted.gpg Keyring

    Updated:August 9, 20222 Mins Read

    How to list all collections in MongoDB database

    1 Min Read

    Leave A Reply Cancel Reply

    Recent Posts
    • How to Import GPG Keys on Ubuntu & Debian (without apt-key)
    • How To Install Google Chrome On macOS
    • How to Install Minecraft on Ubuntu 22.04 & 20.04
    • Running a Cron job every Sunday (Weekly)
    • Running Multiple Commands At Once in Linux
    Facebook Twitter Instagram Pinterest
    © 2022 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.