SELECT command denied to user 'user@'xxx.xxx.xxx.xxx' 'for table...

Expand / Collapse
 
     

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'


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

"server=mysqlxxx.mysite4now.com;user id=dbuser; password=dbpassword; database=dbname; Use Procedure Bodies=false;"

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





Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:4/13/2009 12:58 AM
Last Modified By: Mark
Type: How to fix a problem
Rated 2 stars based on 1 vote.
Article has been viewed 6,851 times.
Options