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


  • Hello!
    I am trying to reset the encryption data for all of our hosts and the web console will not let me add all hosts into a group so I am attempting to do this with MySQL however I cannot access it and keep getting the following: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO). I looked through old posts and online and am not sure how to access it. We are currently on CentOS 6.9 with FOG 1.5.9. Any suggestions? Thanks!

  • Senior Developer

    @zaccx32 Find the database information in /var/www/html/fog/lib/fog/config.class.php - with FOG 1.5.9 the database user is called fogmaster instead of root that was used in earlier versions. So to login you run this command on the console:

    mysql -u fogmaster -p
    ...
    

364
Online

8.6k
Users

15.3k
Topics

143.5k
Posts