mysql and .net: when using tableadapters I’m getting MySqlException “insert command denied for user”, otherwise everything is fine

Question

Hi!

I am using mysql as db for my asp.net application. Here are the facts:

I am using connection string from web.config which has both username and password. I can do SELECT with tableadapter. When I am trying to do INSERT with tableadapter, I am getting "mysqlexception insert command denied for user" error When I try to do INSERT programatically, i.e. using connection, command object, etc. everything is fine. In this case, I'm reading connection string from web.config, too. This can be only applied to GoDaddy hosting, but on local machine I don't have this kind of problems. Can anyone suggest what can I do to make it work on GoDaddy hosting?

Regards, D

Answer 1

Does the user, that you are connecting to MySql, have Create permission?

Answer 2

Did a quick search for you, try follows:

http://oscarvalles.wordpress.com/2008/01/31/mysql-insert-statement-does-not-post-in-godaddy-acct-mysql-50/

basically, "The database prefix is needed when you write your insert statement so that it can execute."