Which MySQL users have access to a database?

Solution 1:

You can append \G to the command to get results displayed in 'grid' veiw

SELECT * FROM mysql.db WHERE Db = '<database name in LC>'\G;

Solution 2:

SELECT * FROM mysql.db WHERE Db = '<database name in LC>';

---

Solution 3:

You might give this a try, should provide the best readability:

select db 'DATABASE', host HOST, user USER from mysql.db where db = '<databasename>';

Something more memorizeable for the cli:

select db,host,user from mysql.db;