, 'apps@myhost');
Query OK, 0 rows affected (0.16 sec)

mysql&gt; SELECT * FROM similar_grants WHERE sample_grantee like '%apps%';
+----------------+----------------+----------------------------+
| sample_grantee | count_grantees | similar_grantees           |
+----------------+----------------+----------------------------+
| 'apps'@'%'     |              2 | 'apps'@'%','apps'@'myhost' |
+----------------+----------------+----------------------------+

mysql&gt; SHOW GRANTS FOR 'apps'@'%';
+----------------