Configure Munin to graph MySQL on CentOS 5/6 with Virtualmin

If you’re running a CentOS 5/6 VPS/Server with Virtualmin and installed Munin to graph the system stats, you’ll mostly likely notice that the generated graphs do not include MySQL.

This is expected behaviour since Virtualmin asks you to define a root password for your MySQL server (so it isn’t left unsecured out in the open), while Munin tries to read MySQL data using the root account and no password and fails.

But there’s an easy way to fix this…