Error: SELECT command denied to user 'user'@'x' for table 'proc'

Error: SELECT command denied to user 'user'@'x' for table 'proc'

The reason is an error in the MySQL driver. Documented here: http://bugs.mysql.com/bug.php?id=10640 http://bugs.mysql.com/bug.php?id=16703 http://bugs.mysql.com/bug.php?id=14836

A process tries to execute a SELECT-statement on the proc table. This 'proc' table is a system table that stores procedures for all users on the MySQL server. On shared hosting, access to this table is a problem, as access will allow customers to see each other's procedures.

One possible solution to the problem is to change one's connection string to include "Use Procedure Bodies=false".

Ex.: "server=localhost; user id=dbuser; password=password; database=dbname; Use Procedure Bodies=false;"

Article from category ASP & ASP.NET