MySQL Agent User Permissions (233651)

Create a MySQL Database User by logging into the MySQL server and granting the privileges identified below.

User privileges required for the MySQL agent on the host machine:

• SELECT
• REPLICATION CLIENT (if monitoring replication)
• PROCESS
• SUPER (for MySQL versions below 5.1.24)

If monitoring a replication slave server with the agent, that database user must have:

• SELECT
• REPLICATION CLIENT

Example 1:

CREATE USER ''@'' IDENTIFIED BY '';
GRANT SELECT, REPLICATION CLIENT, PROCESS ON *.* TO ''@'';
FLUSH PRIVILEGES;

e.g.

CREATE USER ‘MySQLuser’@’localhost’ IDENTIFIED BY ‘MySQLpassword’;
GRANT SELECT, REPLICATION CLIENT, PROCESS ON *.* TO ‘MySQLuser’@’localhost’;
FLUSH PRIVILEGES;

or Example 2:

GRANT SELECT, REPLICATION CLIENT, PROCESS ON *.* TO ''@'' IDENTIFIED BY '';
FLUSH PRIVILEGES;

e.g.

GRANT SELECT, REPLICATION CLIENT, PROCESS ON *.* TO ‘MySQLuser’@’localhost’ IDENTIFIED BY ‘MySQLpassword’;
FLUSH PRIVILEGES;