Tag Archive | "mysql odbc"


MySQL select command denied

When you use asp.net odbc connector to manage the mysql database you might get this error:

SELECT command denied to user ‘user@’xxx.xxx.xxx.xxx’  ‘for table ‘proc’

Below solution is applied for MySQL Connector/ODBC 5.1.

When users connect their Mysql database with Mysql .Net connector and try to create stored procedure, Mysql will return error:

SELECT command denied to user ‘user@’xxx.xxx.xxx.xxx’  ‘for table ‘proc’

It is a bug in Mysql

To fix it, please add "Use Procedure Bodies=false;" to the connection string:    

"server=;user id=dbuser; password=dbpassword; database=dbname; Use Procedure Bodies=false;"

ref: http://bugs.mysql.com/bug.php?id=35938


Posted in SQL ServerComments (6)