Error 1146 Table 'mysql.proc' doesn't exist.

Friday, 05 February 2010 15:10
User Rating: / 44

error mysql

Sometimes our support team receive a helpdesk request concerning this error message: Error 1146 Table 'mysql.proc' doesn't exist.

The usual problem with such a customers is that almost all of them make recent upgrade of MySQL server. While some releases of MySQL introduce changes in the structure of the system tables in mysql database to add new privileges and support new features, it is necessary to update the system tables as well. Error 1146 Table doesn't exist Fixed!

This error 1146:Table 'mysql.proc' doesn't exist by running mysql_fix_privilege_tables script in MySQL prior to version 5.1.7 or mysql_upgrade in version 5.1.7 or above.

For more details check following links:

top *table 'mysql.proc' doesn't exist'*