Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: How do I reset the admin password?

  1. #1
    clint's Avatar
    clint is offline SugarCRM CTO & Co-founder
    Join Date
    Aug 2004
    Location
    Silicon Valley
    Posts
    2,122

    Default How do I reset the admin password?

    Quote:
    Originally Posted by kornshell
    ive recently installed sugarCRM 4.5 (bitrock installer) and i cant seem to add new (admin users) to the system.need to install admin panel. please advice which software versions to install and how to's. thanks

    Hello kornshell -

    Can you still log into the application using the password for the 'admin' user? You set the 'admin' user password during the installation process.

    If you can successfully log into the application with the 'admin' user, then simply click on the Admin link in the upper right of the app and then click on User Management to modify any user's display name and password.

    If you do not remember that user's password, you will need to access the database directly and execute this SQL command.

    Code:
     update users set user_hash = md5('clint') where user_name = 'admin';
    Change the value new_password to whatever password you want.

    Regards,
    Clint
    _____
    Sugar Developer Zone - developer resources | Sugar University - user and admin training
    Sugar Docs - user and admin documentation |
    Sugar Bug Tracker - Enter or view bugs
    SugarForge- open source modules, themes, lang packs | SugarExchange - commercial extensions

    Clint Oram
    Chief Technology Officer and Co-founder
    SugarCRM

  2. #2
    SugarNoobie is offline Junior Member
    Join Date
    Jul 2010
    Posts
    3

    Default Re: How do I reset the admin password?

    Hello can please tell me how can i access the sql database in sugar crm. I have the same problem with the topic starter, and i am still a novice using linux operating system can you please help me how to access the database of sugar.


    Thnaks

  3. #3
    salesagility's Avatar
    salesagility is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,494

    Default Re: How do I reset the admin password?

    It depends on whether you are using a hosted service or have your own server ... if you are using a hosted server ... look to the technical support from your hosting panel or your control panel. If you have your own server, you should speak to your local system administrator
    The Open Source Awards are back For 2014

    Check out the open source awards at opensourceawards.org

    Committed to Open Source

    SalesAgility - SugarCRM Community Edition Experts

    Authors of:

    Advanced Open Sales - Quotations, Invoices, Products, PDF Templates and Contracts modules for SugarCRM Community Edition
    Advanced Open Workflow - Workflow for SugarCRM Community Edition
    Advanced Open Events - Events module for SugarCRM Community Edition
    Advanced Open Portal - Portal for SugarCRM Community Edition
    Suite CRM - SugarCRM supercharged!!

  4. #4
    SugarNoobie is offline Junior Member
    Join Date
    Jul 2010
    Posts
    3

    Default Re: How do I reset the admin password?

    sad to say, I am the system and network administrator here we have our own server our own operating system is linux cent OS,

    I have accessed on the operating system can you tell me how to change the directory to the apache so that i can put this code.


    update users set user_hash = md5('clint') where user_name = 'admin';


    to change the password.

    Thanks for the reply

  5. #5
    salesagility's Avatar
    salesagility is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,494

    Default Re: How do I reset the admin password?

    ok ... try putting "localhost/phpmyadmin" into your browser

    if you have phpmy admin installed ... it will launch

    then select the database that sugar is installed on in the left hand menu, click on the sql tab and paste the query into the window, click on go, that should do it
    The Open Source Awards are back For 2014

    Check out the open source awards at opensourceawards.org

    Committed to Open Source

    SalesAgility - SugarCRM Community Edition Experts

    Authors of:

    Advanced Open Sales - Quotations, Invoices, Products, PDF Templates and Contracts modules for SugarCRM Community Edition
    Advanced Open Workflow - Workflow for SugarCRM Community Edition
    Advanced Open Events - Events module for SugarCRM Community Edition
    Advanced Open Portal - Portal for SugarCRM Community Edition
    Suite CRM - SugarCRM supercharged!!

  6. #6
    SugarNoobie is offline Junior Member
    Join Date
    Jul 2010
    Posts
    3

    Default Re: How do I reset the admin password?

    Hello sales Agility,

    Thanks for the reply.

    Is there a way to execute the query without using phpMyAdmin?
    Last edited by SugarNoobie; 2010-07-07 at 10:42 AM.

  7. #7
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,491

    Default Re: How do I reset the admin password?

    You can run this sql through mysql command line, but it is not pretty much user friendly.

    Regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  8. #8
    abhax's Avatar
    abhax is offline Senior Member
    Join Date
    Jun 2010
    Location
    India
    Posts
    65

    Smile Re: How do I reset the admin password?

    From the command line

    just open the terminal

    >mysql -u <username here> -p

    it will prompt for pasword enter your mysql password here.
    then you will have

    mysql>

    mysql> show databases;
    This will show all the databases there are.

    mysql>use <SugarDatabase>

    the name of the db u used for SugarDB

    mysql>Database changed
    u will recieve this message


    mysql>show tables;
    It will show all the tables in the DB

    mysql> Run The Command The Change The Password.



    Hope that helps
    If It Is To Be, It Is Up To Me

  9. #9
    rob0 is offline Junior Member
    Join Date
    Feb 2011
    Posts
    1

    Default Re: How do I reset the admin password?

    Quote Originally Posted by SugarNoobie View Post
    sad to say, I am the system and network administrator here we have our own server our own operating system is linux cent OS,

    I have accessed on the operating system can you tell me how to change the directory to the apache so that i can put this code.


    update users set user_hash = md5('clint') where user_name = 'admin';


    to change the password.
    Thanks. This worked for me with phpmyadmin.

  10. #10
    gsrikanth's Avatar
    gsrikanth is offline Sugar Community Member
    Join Date
    Dec 2008
    Location
    Hyderabad
    Posts
    49

    Default Re: How do I reset the admin password?

    Is this md5() function true for sugar 6.3 login through SOAP interface?
    It is displaying error message "Login attempt failed please check the username and password" when i try to login.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •