@user What's not said in the answer is that you should be using the mysql database. That's where all the data used by MySQL is stored. Either give the command USE mysql; of add the database name to the table names, such as FROM realtime-windowsserver.com or FROM realtime-windowsserver.com_priv – . Nov 28, · If you are running a multi-user MySQL database, handy commands that show a list of all existing MySQL users and their privileges may be on your cheat sheet. To find out all MySQL users and the permissions granted to each user, log in to your MySQL server, and run the following MySQL commands. To get a list of MySQL users. I have a MySQL pair that communicates over a VIP. I want to verify permissions for all users (including root) from ANY IP. When I attempt to view all grants for root I get this: mysql> show grants for root; ERROR (): There is no such grant defined for .