Grant MySQL Permissions

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

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

mysql -u root -p

2. 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'"

3. 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.

4. 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';