/*5. How to grant a user permission to create, insert, update, delete and create temporary tables from any host.
*/
/*Syntax :

grant [<permission_1,permission_2,...permission_n>|<all>] 
on [database].[<table_name>|<all_tables(*)>] 
to [user name]@[<localhost>|<IP address>|<any host('%')>] 
identified by ["password"];
*/

grant select, create, insert, update, delete, create temporary tables on posts.* 
to amit@'%' identified by 'mypassword';
flush privileges;
