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

[zaccx32]

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!

[Sebastian Roth]

@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
...