And eventually, allowing access to performance_schema for my test user, makes it visible in information schema. E.g.:
mysql root> GRANT SELECT ON performance_schema.* TO 'tester42'@'localhost';
---
mysql tester42> SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema';
+----------+
| COUNT(*) |
+----------+
| 87 |
+----------+
1 row in set (0.00 sec)
And eventually, allowing access to performance_schema for my test user, makes it visible in information schema. E.g.:
mysql root> GRANT SELECT ON performance_ schema. * TO 'tester42' @'localhost' ;
---
mysql tester42> SELECT COUNT(*) FROM INFORMATION_ SCHEMA. TABLES WHERE TABLE_SCHEMA = 'performance_ schema' ;
+----------+
| COUNT(*) |
+----------+
| 87 |
+----------+
1 row in set (0.00 sec)