Comment 13 for bug 1686603

Revision history for this message
Teodor Milkov (tm-del) wrote :

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)