Access denied for user 'root'@'localhost' (using password: YES)

[cku123]

Hello,

I am using MySQL as the database for my SugarCRM application. I have been playing with the users and hosts in MySQL so that I can connect to the MySQL database from other workstations. In the process, I seemed to have messed up the 'root' user. Now I am unable to connect to the database. I get the Access denied for user 'root'@'localhost' (using password: YES) error when I try to open the MySQL administrator or try any type of connection.

How can I re-enable the 'root' user without having to re-install?

Any help is greatly appreciated!!

Thanks,
CK.

[mikesolomon]

is there a user set up in mysql root@localhost ?

can you access mysql from the command line?

if so do

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

where 'some_pass' is the password you want to use

[mikesolomon]

Hello,

I am using MySQL as the database for my SugarCRM application. I have been playing with the users and hosts in MySQL so that I can connect to the MySQL database from other workstations. In the process, I seemed to have messed up the 'root' user. Now I am unable to connect to the database. I get the Access denied for user 'root'@'localhost' (using password: YES) error when I try to open the MySQL administrator or try any type of connection.

How can I re-enable the 'root' user without having to re-install?

Any help is greatly appreciated!!

Thanks,
CK.

what u have probably done is changed root@localhost to root@%

u need two users one root@% that can access from any machine and root@localhost to access from localhost - hope that makes sense

[ptemplin7]

Since your have been playing around witht eh hosts file. as suggested above. Login using the root@<IP> you last set int eh host file.

a tool like myphpadmin, if you can get in is very useful for seeing what is in the actual tables. Also, may help you set us the various combination of root@???? you need to get it working again.

I forget where I got it, but there is a method for disabling the mysql protection allowing you access with out the authetication. This can be found by searching on the web. Once disabled, get in, reset the master password and clean up what caused the problem in the first place.

Good luck,
Paris

[Angel]

It is also possible that you might need to re-install the privileges tables.

You can do that via the mysql_install_db utility.

Make sure you backup your data beforehand.

More info on mysql_install_db: http://dev.mysql.com/doc/refman/5.0/...nstall-db.html

[hosseinjafaryjozany]

is there a user set up in mysql root@localhost ?

can you access mysql from the command line?

if so do

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

where 'some_pass' is the password you want to use

i did and lost access to mysql .are you sure?