The view mysql_innodb_cluster_metadata.v2_this_instance references performance_schema.global_variables which the mysqlrouter user does not have permissions for.
v2_this_instance | CREATE ALGORITHM=UNDEFINED DEFINER=`clusteruser`@`10.5.0.4` SQL SECURITY INVOKER VIEW `v2_this_instance` AS select `i`.`cluster_id` AS `cluster_id`,`i`.`instance_id` AS `instance_id`,`c`.`cluster_name` AS `cluster_name`,`c`.`cluster_type` AS `cluster_type` from (`v2_instances` `i` join `clusters` `c` on((`i`.`cluster_id` = `c`.`cluster_id`))) where (`i`.`mysql_server_uuid` = (select convert(`performance_schema`.`global_variables`.`VARIABLE_VALUE` using ascii) from `performance_schema`.`global_variables` where (`performance_schema`.`global_variables`.`VARIABLE_NAME` = 'server_uuid'))) | utf8mb4 | utf8mb4_0900_ai_ci |
Adding charmhelpers to the bug. Needs: "GRANT SELECT ON performance_schema.global_variables"
The view mysql_innodb_ cluster_ metadata. v2_this_ instance references performance_ schema. global_ variables which the mysqlrouter user does not have permissions for.
v2_this_instance | CREATE ALGORITHM=UNDEFINED DEFINER= `clusteruser` @`10.5. 0.4` SQL SECURITY INVOKER VIEW `v2_this_instance` AS select `i`.`cluster_id` AS `cluster_ id`,`i` .`instance_ id` AS `instance_ id`,`c` .`cluster_ name` AS `cluster_ name`,` c`.`cluster_ type` AS `cluster_type` from (`v2_instances` `i` join `clusters` `c` on((`i` .`cluster_ id` = `c`.`cluster_id`))) where (`i`.`mysql_ server_ uuid` = (select convert( `performance_ schema` .`global_ variables` .`VARIABLE_ VALUE` using ascii) from `performance_ schema` .`global_ variables` where (`performance_ schema` .`global_ variables` .`VARIABLE_ NAME` = 'server_uuid'))) | utf8mb4 | utf8mb4_0900_ai_ci |
Adding charmhelpers to the bug. Needs: "GRANT SELECT ON performance_ schema. global_ variables"