MySQL munin plugin: connection problems for 5.0.89
|Reported by:||yonas||Owned by:||nobody|
I created a user "munin" with SUPER privileges. I get connection problems unless I grant a random privilage for "munin" on the "mysql" database (very strange....).
root# munin-run mysql_innodb_tnx DBI connect('mysql;mysql_connect_timeout=5','munin',...) failed: Access denied for user 'munin'@'localhost' to database 'mysql' at /etc/munin/plugins/mysql_innodb_tnx line 876
[mysql*] env.mysqladmin /usr/bin/mysqladmin env.mysqluser munin env.mysqlpassword xxxxxxxxx
Once it works at least once, I change remove all the extra privilages I gave it for "mysql" database, and the plugin will continue to work. If I restart mysql server, the connection is dropped and I have to repeat this process.