enable munin to monitor mysql

I red here http://blog.jploh.com/2007/06/14/how-to-install-munin-on-centos/ that

If your root user has a password (or want to use a different user), edit the plugin configuration file in /etc/munin/plugin-conf.d/munin-node and uncomment line 16 by removing the leading hash (#). Then change the parameters that will be used when mysqladmin is run.

this is the file in question - what do I need to change to allow munin to collect that info?

#
# This file contains configuration options for the plugins. Three
# options are understood by munin-node itself:
#
#       user <user>         # Set the user to run the plugin as
#       group <group>       # Set the group to run the plugin as
#       command <command>   # Run <command> instead of the plugin. %c
#                             expands to what would normally be run.
#   env.<variable>      # Sets <variable> in the plugin's environment, see the
#                         individual plugins to find out which variables they
#                         care about.
#
#

[mysql*]
#env.mysqlopts -u someuser

[exim*]
group mail

[cps*]
user root

[apt]
user root

[vlan*]
user root

[postfix*]
user root

Open in new window

ee-gdAsked:
Who is Participating?
 
torimarConnect With a Mentor Commented:
Try:

[mysql*]
env.mysqlopts -u root -p[password]

Open in new window


Replace [password] by the pass of your MySQL root user.
(Omit the brackets and make sure to not leave a blank space after '-p')
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.