12) When I try to login I get an error saying; mysql connect() (function.mysql-connect): Access denied for user 'root'@'localhost' (using password: YES)?

From OrangeHRM

Jump to: navigation, search

This could be a result of incorrect MySQL server username/password set in the Conf.php. The Conf.php is located in /orangehrm/lib/confs/ and should be set as; 

          $this->dbhost = '<IP address of MySQL server>';
          $this->dbport  = '<port no, of MySQL server>';
          $this->dbuser = '<username>';    the user name of the account you created 
          $this->dbpass = '<password>';    the user name of the account you created 
          $this->smtphost = '<SMTP server DNS or IP address>'; the DNS or IP address

If the usernames and passwords given are correct in Conf.php, it could be that the user does not have required rights for OrangeHRM database. To create a user with required rights execute this command in MySQL prompt; 

         grant all privileges on hr_mysql.* to '<username>'@'%'  identified by '<password>'
                                              OR
         grant all privileges on hr_mysql.* to '<username>'@'localhost'  identified by '<password>'
Retrieved from "http://www.orangehrm.com/wiki/index.php/12%29_When_I_try_to_login_I_get_an_error_saying%3B_mysql_connect%28%29_%28function.mysql-connect%29:_Access_denied_for_user_%27root%27%40%27localhost%27_%28using_password:_YES%29%3F"
Personal tools