MySQL stored procedures: Command denied error


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.


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

"Use Procedure Bodies=false;"

Add Feedback