Permission / Privilege

Grant permission

grant { all | <privilege>[, ...] }
  on {*|<database>}.{*|<table>}
  to '<user>'@'<host>'
  [with grant option];

-- commit changed permission
flush privileges;

<privilege>

select | insert | update | delete | ...

with grant option

• Allow user to grant permission to other user

Show permission

show grants [for <user>];