Grant MySQL Permissions

To enable Pulse to collect Hive and Oozie metadata stored in MySQL, you must grant the required permissions.

• ---

  Log in to MySQL as the root or an administrative user.

mysql -u root -p

• Create the users (if they do not already exist):

"CREATE USER 'hive'@'pulse_host' IDENTIFIED BY 'password'"
"CREATE USER 'oozie'@'pulse_host' IDENTIFIED BY 'password'"

• Grant read-only (SELECT) privileges (replace placeholders with actual values):

GRANT SELECT ON hive_database.* TO 'hive_user'@'pulse_host' IDENTIFIED BY 'password';

GRANT SELECT ON oozie_database.* TO 'oozie_user'@'pulse_host' IDENTIFIED BY 'password';

The commands vary depending on the MySQL version.

• hive_database / oozie_database: Names of the Hive and Oozie metadata databases.
• hive_user / oozie_user: Usernames Pulse uses to access these databases.
• Pulse_host: Hostname or IP address of the Pulse server. Use % to allow access from any host.
• Password: Password assigned to the database user.

• Apply changes.

FLUSH PRIVILEGES;

Example:

GRANT SELECT ON hive.* TO 'hivepulse'@'192.168.1.10' IDENTIFIED BY 'Hive@123';
GRANT SELECT ON oozie.* TO 'ooziepulse'@'192.168.1.10' IDENTIFIED BY 'Oozie@123';