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 the support category: ASP & ASP.NET
