After upgrading MySQL from MySQL 5.1 to MySQL 5.6 in CentOS6.4 today, when using the NavicatPremium client management tool, I found that the smart prompt for writing SQL statements is not
After upgrading MySQL from MySQL 5.1 to MySQL 5.6 in CentOS6.4 today, when using the Navicat Premium client management tool, I found that the smart prompt for writing SQL statements is not
After upgrading MySQL from MySQL 5.1 to MySQL 5.6 in CentOS6.4 today, when using the Navicat Premium client management tool, I found that the smart prompt for writing SQL statements is gone, this is definitely not a problem with the configuration of management tools. I tested this problem on another machine named MySQL5.5.
If I create a table and want to save and back up the table structure, the following error is prompted:
Cannot load from mysql. proc. The table is probably specified upted
As follows:
I searched for a solution on the Internet. Almost all the articles said this:
Run the following command:
Mysql_upgrade-uroot-p Password
I tried it for countless times. It is not valid for me. The problem is still not solved because it does not affect my work, so I temporarily put it down and did not handle it.
When I was idle and bored, I was searching for a solution to this problem. I found this article:
That is, since MySQL, the attribute of the comment field in the proc table has been changed from char (64) to text. We need to change the data type:
Alter table 'proc'
Modify column 'comment' text character set utf8 COLLATE utf8_bin not null after 'SQL _ mode ';
Finally, the problem is solved.