Prerequisites for adding MYSQL Server

Minimum User Privileges to Grant

The user should have privileges to execute SELECT, SHOW DATABASES, REPLICATION commands in the MySQL server. Also, Applications Manager machine should be allowed to access the MySQL database server.

For enabling the privileges, execute the below commands in the remote MySQL Server:

INSERT INTO user (Host,User) VALUES(’’,’’);

GRANT SELECT,SHOW DATABASES,REPLICATION CLIENT ON . TO ‘’@’’;

FLUSH PRIVILEGES;

(Host -> Applications Manager machine) /