Sometimes MySQL changes its internal database structures between versions. When that is the case, you might get errors after updating it and trying to start it back up or when trying to perform particular operations on the databases (dumps for example).
The solution is rather simple and involves…
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…
