How do I reset the admin password?

[clint]

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.

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

Change the value new_password to whatever password you want.

Regards,
Clint
_____

[SugarNoobie]

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

[salesagility]

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

[SugarNoobie]

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

[salesagility]

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

[SugarNoobie]

Hello sales Agility,

Thanks for the reply.

Is there a way to execute the query without using phpMyAdmin?

[andopes]

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

Regards

[abhax]

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

[rob0]

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.

[gsrikanth]

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.