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 SugarCRM Admin Password via SQL or phpMyAdmin

    Reset SugarCRM Admin Password via SQL or phpMyAdmin

    RahulBy RahulOctober 18, 20171 Min ReadUpdated:December 5, 2017

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

    If you have forgotten your SugarCRM admin password or due to any reason, you are not able to login to SugarCRM with admin user. You can simply check the active admin user using SQL query and reset the password with simple SQL query.

    Reset SugarCRM Admin Password via SQL

    The first query will fetch the active admin accounts from your SugarCRM database.

    MySQL
    1
    SELECT user_name FROM users WHERE is_admin = '1' AND status = 'Active';

    SugarCRM uses md5 encrypted passwords. The query will change the password for the specified username. You must change SECRET_PASSWORD with your password and USERNAME with admin account username get in above query.

    MySQL
    1
    UPDATE users SET user_hash = MD5('SECRET_PASSWORD') WHERE user_name = 'USERNAME';

    Reset SugarCRM Admin Password via phpMyAdmin

    You can also connect SugarCRM database with phpMyAdmin and reset the admin password. Open table users and edit the record of the admin user. Now under the user_hash column, select the MD5 in functions and put plain text password in value section and save it.

    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp
    Previous ArticleHow to Deploy Ruby Application with Passenger and Apache on CentOS 7/6, Fedora 27
    Next Article How to Install TeamViewer 15 on Linux

    Related Posts

    How to Find Django Install Location in Linux

    Updated:April 27, 20221 Min Read

    (Resolved) – ReactJS 404 Error on Page Reload

    2 Mins Read

    Adding a New SSH Key in GitHub

    Updated:April 1, 20223 Mins Read

    13 Best Linux Terminal Emulators and Bash Editors

    8 Mins Read

    How To Install Oracle VirtualBox on Debian 11

    2 Mins Read

    10 Best Linux FTP Clients in 2022

    5 Mins Read

    1 Comment

    1. Howard on March 17, 2021 7:56 am

      Thank you. Very. Much!

      Reply

    Leave A Reply Cancel Reply

    Recent Posts
    • How to Enable / disable Firewall in Windows
    • How to Install JAVA on Ubuntu 22.04
    • Switching Display Manager in Ubuntu – GDM, LightDM & SDDM
    • Changing the Login Screen Background in Ubuntu 22.04 & 20.04
    • How To Install PHP (8.1, 7.4 or 5.6) on Ubuntu 22.04
    Facebook Twitter Instagram Pinterest
    © 2022 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

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