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!!