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

Question

Accepted Answer

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;"

Most read articles

Support categories

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