DX Unified Infrastructure Management

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

User Access Requirements

The mysql probe monitors local and remote MySQL servers. The configured users must have access to the information_schema database and the following queries on the MySQL server:

• SHOW GLOBAL STATUS

• SHOW SLAVE STATUS

• SHOW VARIABLES

• SHOW DATABASES

• SELECT TABLE_NAME, AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, TAB

mysql (MySQL Server Monitoring) Release Notes - CA Unified Infrastructure Management Probes - CA Technologies Documentat… 

Hi David,

Thanks for your answer, but I checked the docs and what I want to know is how do I give permissions of only-view for all databases to a new user?

Regards

Oh, so it is a question on mysql and not the probe.

In that case the mysql documentation is the place.

MySQL :: MySQL Documentation 

Hi Jean,

Your query looks right to me, but I would probably want something more like this, so that monitor can connect from any box:

GRANT ALL PRIVILEGES ON *.* TO 'monitor'@'%';

To save the changes, be sure to:

FLUSH PRIVILEGES;

Best,

Mary

Hi Mary,

Thanks for your answer.

I will test the command of privileges with '%' and let you know.

Regards,

JG