Many times am I asked what privileges do i need for this user. Explaining them can be confusing so I made this to share with everyone to help them understand MySQL users and privileges. Hopefully this will help you in deciding proper permissions for users. Click image below to download the pdf.

The attached pdf has a  table that anticipates that you want to know two things about privileges:

• What action is permitted: Read either the “What action is permitted” column, or the “Privilege Column Name” column
• At what level of granularity can it be set: For the privilege you’re interested in, note the “X”‘s, and read up the table to see which privilege tables provide that privilege, and then inspect their Key columns to understand the level of granularity.