SELECT command denied to user ...

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 1
Joined: Fri 27 Jan 2012 18:35

SELECT command denied to user ...

Post by valerii.sverdlik » Fri 27 Jan 2012 18:48

Hi! Trying to use dotConnect with EntityFramework and MySql. My ConnectionString is:

When trying to connect to any table of the database I get an exception:

SELECT command denied to user 'user'@'' for table 'OrganizationPlans'

While I was using standard connector(MySql.Data.MySqlClient) I had no this issue. Why can this happen?

Thanks in advance.[/img]

Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 30 Jan 2012 14:47

Please check if a correct schema (database) name is used in the queries. You can do that with the dbMonitor tool.
Download link:
Documentation: ... nitor.html

If the reason is a schema name, there are two solutions:
1) turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: ... orkarounds
2) remove Schema attributes from your EntitySets in SSDL (with Entity Developer or with XML Editor).

We have removed your duplicate post.

Post Reply