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

Friday, 05 February 2010 15:10

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'*

< Prev

Comments

+2 #3 2011-07-05 12:16

Don't know if this will help anyone, but I had this issue on Linux (when it'd been fine on Windows) and it transpired to be a case sensitivity issue (I was using MySQL not mysql).

http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html

Running: "show databases" should show you the database names and their case (if you have permission).

Hope that helps someone!

Paul.

Quote

0 #2 2010-04-19 08:44

After to create a stored procedure on a MySQL 5.0.65 , I received the following error:

ERROR 1146 at line 23: Table 'mysql.proc' doesn't exist

The server had the default MySQL 4.1.21 that comes with Red Hat Enterprise Linux 4, and it was upgraded to MySQL 5.0.65. After the upgrade, the mysql_upgrade script wasn't run, so the privilege tables were wrong, and the special tables for procedures and triggers did not exist.

To fix the problem, I ran:

# /usr/bin/mysql_upgrade

After about 30 seconds, the script completed and I was able to add a stored procedure without a problem.

Quote