I am sure many of you like me have ran into the issue of Munin MySQL stats stop working usually after a server restart or some other event. Well today I show you the simple fix for the problem.
First make sure that the MySQL root password in /root/.my.cnf is valid.
Then browse to /etc/munin/plugin-conf.d , you will see a file called cpanel.conf . Modify it completely to look like so:
[mysql*] user root group wheel env.mysqlopts --defaults-extra-file=/root/.my.cnf [exim_mailqueue] group mail [exim_mailstats] group mail [mailman] user mailman
Then restart munin with the command below.
Once you have restarted Munin give it 5 minutes then check to see that your stats are starting to update.