How MySQL show, grant or revoke user privileges

I wrote this post to memo the basic MySQL commands to show, grant, or revoke user privileges. Firstly, let’s show all users and hosts of my current MySQL instance by the following command: 1, Show Privileges for a user in MySQL Also, we can check the permissions for the currently logged in user with: 3, … Read more