grant select, insert, execute on dev to ‘hoge@%’ indeintified by ‘password’

grant select, insert, update on ${table_name}.* to user@’%’ identified by ‘password’

mysql> create database dev;
Query OK, 1 row affected (0.14 sec)

mysql> use dev;
Database changed
mysql> grant select, insert, update, delete execute on dev.* to 'user'@'%' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'execute on dev.* to 'user'@'%' identified by 'password'' at line 1
mysql> grant select, insert, update, delete, execute on dev.* to 'user'@'%' identified by 'password';
Query OK, 0 rows affected (0.19 sec)

ほーーーーーー