Grant MySQL Permissions

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

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

Last updated on

Was this page helpful?