Prepare to run the MySQL collector

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • Create a MySQL user and grant permissions before running the collector.

    Before you begin

    Role required: admin

    About this task

    Configure a MySQL user with the minimum required permissions for metadata harvesting.

    Procedure

    1. Create a user. 
      CREATE USER 'catalog_user'@'%' IDENTIFIED BY '<password>';

      Replace <password> with a secure password.

    2. Grant permissions to the user. 
      GRANT SELECT, SHOW VIEW, EXECUTE ON *.* TO 'catalog_user'@'%';

      This grants the following permissions:

      • SELECT: Read access to tables and views
      • SHOW VIEW: View definition access
      • EXECUTE: Stored procedure and function access