MySQL Agent User Permissions (4225880)

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)
• CREATE TEMPORARY TABLES (only for MySQL PI integration)

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

• SELECT
• REPLICATION CLIENT

Example 1:

CREATE USER '[username]'@'[host or ip]' IDENTIFIED BY '[PASSWORD]';
GRANT SELECT, REPLICATION CLIENT, PROCESS, CREATE TEMPORARY TABLES ON *.* TO '[username]'@'[host or ip]';
FLUSH PRIVILEGES;

e.g.

CREATE USER 'MySQLuser'@'%' IDENTIFIED BY 'MySQLpassword';
GRANT SELECT, REPLICATION CLIENT, PROCESS, CREATE TEMPORARY TABLES ON *.* TO 'MySQLuser'@'%';
FLUSH PRIVILEGES;

or Example 2:

GRANT SELECT, REPLICATION CLIENT, PROCESS, CREATE TEMPORARY TABLES ON '[username]'@'[host or ip]' IDENTIFIED BY '[PASSWORD]';
FLUSH PRIVILEGES;

e.g.

GRANT SELECT, REPLICATION CLIENT, PROCESS, CREATE TEMPORARY TABLES ON *.* TO 'MySQLuser'@'%' IDENTIFIED BY 'MySQLpassword';
FLUSH PRIVILEGES;