Lost Admin Password on Windows XP

[sloan]

Ok I forgot my admin password for this instance of Sugar 4.5.1 on XP. Somebody shoot me, please.
So to recover i did this what is listed below. After all that I get this error

Could not connect to server localhost as root.Client does not support authentication protocol requested by server; consider upgrading MySQL client

when I try to start sugar. Any Ideas please?

Log on to your system as Administrator.

Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:

Start Menu -> Control Panel -> Administrative Tools -> Services

Then find the MySQL service in the list, and stop it.

If your server is not running as a service, you may need to use the Task Manager to force it to stop.

Create a text file and place the following command within it on a single line:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

Save the file with any name. For this example the file will be C:\mysql-init.txt.

Open a console window to get to the DOS command prompt:

Start Menu -> Run -> cmd

We are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly.

At the DOS command prompt, execute this command:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

The contents of the file named by the --init-file option are executed at server startup, changing the root password. After the server has started successfully, you should delete C:\mysql-init.txt.
################################################## ###########
Thanks to Max Blackmer for the steps above


Then I created one of the new users

grant all privileges on *.* to 'admin'@'localhost' identified by 'a546f456' with grant option;
flush privileges;

No when I fire up my browser I get this error message

Could not connect to server localhost as root.Client does not support authentication protocol requested by server; consider upgrading MySQL client

[pblag]

Hi All!

This is something unbelievable!

You've changed the mysql password for user mysql user root.

As you said you forgot the password for SugarCRM

For changing the password of sugar user you just have to go to users table in the sugarcrm database and change the user_hash field for this user.

For example put c4ca4238a0b923820dcc509a6f75849b value into user_hash field for your user and this user will have the password 1

so you can use it for logging into SugarCRM


Now you just changed the mysql user password.
If you remember this password, it is great.

So if Yes you have to do the following things:

1) go to the file config.php in the root sugar directory
2) find the text 'db_password' and put there correct value (your mysql password for user root or admi)

sure there you have write correct mysql user name and password (db_user_name)

BTW: Your mysql server should be started

Hope it will help you.

[sloan]

Ok thanks for the response. I am not finding config.php in the root sugar directory. I know it is there on Linux/Unix. I am on windows on this box. I did find a file in the php directory that is called php in other area it says configuration settings. Kind of sounds like config php. But I find no field called db_password

I did find these two which appear to be close.
mysql.default_password
mysql.default_user

They had no values so I put in a user name and clear text password. Do I need to put in the hashed password from the database sugarcrm. What if I put in user root and the hashed password from the myslq database wont that give ma all access everywhere?

Putting in clear text is not working for me

[alexangus]

Hi, I lost=forgot my admin password, and I am new here and with Sugar/MySql etc

So I found the things below in the forum.
I created the file and tried to execute the command, but it comes up with an error
In the command I changed the name of the text file and also the patch to where mysql\bin is.

as this solution is 2006, maybe some major things have changed.
So I tried mysql and mysqld instead of mysql-nt, but that did not work either.

What should I be doing please?

******************************
Create a text file and place the following command within it on a single line:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

At the DOS command prompt, execute this command:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

[pblag]

Hi!

I think that we can help you.
If you are interested please email me.
Feel free to contact us.