Minimum Rights To Read MySQL

To allow vScope read access to your MySQL server you should make sure that the credentials used in vScope have read access to the following tables and procedures:

  • SHOW DATABASES
    • For each database: SHOW TABLES IN db_name
  • information_schema.TABLES
  • information_schema.ENGINES
  • mysql.user
  • SHOW variables
  • SHOW GLOBAL STATUS
  • SHOW SLAVE STATUS
  • SHOW SLAVE HOSTS

Leave a Reply