Today, colleagues found an error message when using a tool to connect to MySQL, as follows
If there is a problem, look at the error log, also found an error message, as follows
[ERROR] Incorrect definition of Table mysql.proc:expected column ' comment ' at position 15to have type text, found type char (64).
Say it's mysql.proc. The comment field type for this table should be text, but char (64).
As prompted by the error message, just set the Comment field type to text.
Use MySQL;
ALTER TABLE ' proc ' MODIFY COLUMN ' comment ' text CHARACTER SET UTF8 COLLATE utf8_bin null after ' Sql_mode ';
Reconnect MySQL, the error has been resolved!
At the same time, I found a very strange phenomenon, when there is this problem, when using a connection tool such as NAVICAT, the input SQL statement does not have the automatic prompting function, but when the problem is resolved, the automatic prompting function is normal. Interested friends can also experiment!
This article is from the "embrace open source world sharing open Source Technology" blog, please be sure to keep this source http://heisedeyan.blog.51cto.com/3392968/1283165
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/