Comment 15 for bug 1686603

I created the accounts the same way as Teodor did and had the issues so I tried what Teodor's solution by adding the GRANT SELECT permissions on the non-root account and now things are working again. This still does seems like a poor workaround.

mysql -umyuseraccount -p
mysql> SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema';
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+

mysql -uroot -p
GRANT SELECT ON performance_schema.* TO "myuseraccount"@"localhost";

mysql -umyuseraccount -p
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema';
+----------+
| COUNT(*) |
+----------+
| 87 |
+----------+