1#in SQL execute
2#GRANT type_of_permission ON database_name.table_name TO 'username'@'localhost';
3GRANT ALL PRIVILEGES ON * . * TO 'username'@'localhost';
4#reload all the privileges
5FLUSH PRIVILEGES;
6
7#Show Privileges
8SHOW GRANTS FOR 'username'@'localhost';
9
10#Revoke Privileges
11REVOKE type_of_permission ON database_name.table_name FROM 'username'@'localhost';
12