AnsweredAssumed Answered

MYSQL PROBE - Creation of User

Question asked by Jean Gomes on May 11, 2017
Latest reply on May 15, 2017 by Jean Gomes

Hello CA Geeks,

 

I need to monitoring some MySQL Databases.

Someone could share the script of creation of user on MySQL Databases?

 

I tryied the follow script, but doesn't worked. 

 

CREATE USER 'monitor'@'localhost' IDENTIFIED BY 'pass';

GRANT USAGE, SUPER, REPLICATION CLIENT ON *.* to 'monitor'@'localhost'; 

With only these grants, the user 'monitor' don't have permission to view all databases, only information_schema.

Someone could share the script of creation of user on MySQL Databases?

 

Regards,

Jean Gomes

Outcomes