MySQL Workbench cannot load mysql.proc

mysql mysql-workbench
Jakub Mach picture Jakub Mach · Jul 22, 2011 · Viewed 34.5k times · Source

I am starting to use MySQL Workbench tool especially for data modeling. So, the first I would like to do is reverse engineering of my existing database on web server. But I not able to finish the process, because I alway get this strange error message:

Error: Cannot load from mysql.proc. The table is probably corrupted

I tried to repair this table but it not help me. So, do you have any experience with this problem and know how to solve it?

Answer

Kevin picture Kevin · Jul 29, 2011

I'm using MySQL version 5.5.9 on MAC. I fixed this problem by running: 

mysql_upgrade -uroot -p

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More