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