I was trying to execute an INSERT command from my .net application. However I got the following error.
Error Message: INSERT command denied to user 'user_id'@'my_ip' for table 'table_name'
Error Code: 1142
I've used the following commands to create the user and grant the privileges.
CREATE USER 'user_id'@'%' IDENTIFIED BY 'password';
GRANT INSERT ON [Database_Name].[Table_Name] TO 'user_id'@'%';
Also I can use MySQL Workbench on the same machine to execute the INSERT command. Please help. Thanks.