MySQL stored procedures: Command denied error

Issue:

The following error or a variation of it can occur when calling stored procedures on MySQL 5 server:

"MySql.Data.MySqlClient.MySqlException: #42000 SELECT command denied to user ‘XYZ’@’ZYX’ for table ‘proc’."

The error occurs because the user does not have SELECT privledge to mysql.proc table which is used to get parameters for the stored procedures.


Fix:

Add the following parameter to the database connection string (without quotes):

"Use Procedure Bodies=false;"

Add Feedback