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=211.22.24.10;user id=dbuser; password=dbpassword; database=dbname; Use Procedure Bodies=false;"

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

Share

- has written 121 posts.


Leave a Reply

You must be logged in to post a comment.