Grant lock and temp table privilege

To grant the Lock table privilege:
mysql
use mysql;
show tables;
update db set Lock_tables_priv='Y' where Db="DatabaseName" and User="DatabaseUsername";
flush privileges;

To grant the Temp table privilege:
mysql
use mysql;
show tables;
update db set Create_tmp_table_priv='Y' where Db='DatabaseName' and User="DatabaseUsername";
flush privileges;

Make sure that you had given flush privileges.

Modify the DatabaseUsername and DatabaseName according to the requirement.