What Privileges are needed for DBTuna for MySQL?

DBTuna for MySQL needs access to the full processlist. In MySQL version 5 and above this comes with the "SUPER" privilege, the user will also need SELECT, PROCESS and SHOW DATABASE privileges. The easiest way to create a dbtuna user to use for the monitoring agent is as follows:

GRANT SELECT,SUPER,PROCESS,SHOW DATABASES on *.* to 'dbtuna'@'host' identified by 'password';

FLUSH privileges;

* Remember to change 'host' to the hostname or ip address of the machine running the dbtuna software, and 'password' to a suitable secure password.
See http://dev.mysql.com/doc/refman/5.0/en/adding-users.html for more details on how to create a user which can remotely access mysql.

If you have an earlier version of MySQL which does not have the SUPER privilege (to check for this you can look for the Super_Priv column in the mysql.user table), you will have to grant ALL to the dbtuna user i.e.

grant ALL on *.* to dbtuna@'%' identified by 'password';

flush privileges;

N.B. Make sure you change the 'password' to something more secure, and also change the '%' so that the dbtuna user can only access the database from one host (i.e. the host machine where the dbtuna monitoring software is installed.).

Copyright ©2010 DBTuna. All rights reserved.