MySQL's workaround for "Table ' mysql.servers ' doesn ' t exist"

After installing MySQL, once again the system has a problem, so I check the MySQL error log, unexpectedly found the table ' mysql.servers ' doesn ' t exist problem error,

Although it has nothing to do with my question, it still raises my mind.

Analysis to see is missing mysql.servers this table.

After the internet to find a solution, found to solve the problem there are two ways:

Solution One, build this table by yourself.

Use MySQL;
CREATE TABLE ' Servers ' (
' server_name ' char (+) is not NULL,
' Host ' char (+) is not NULL,
' Db ' char (+) is not NULL,
' Username ' char (+) is not NULL,
' Password ' char (+) is not NULL,
' Port ' int (4) DEFAULT NULL,
' Socket ' char (+) DEFAULT NULL,
' Wrapper ' char (+) is not NULL,
' Owner ' char (+) is not NULL,
PRIMARY KEY (' server_name ')
) Engine=myisam DEFAULT Charset=utf8;

Workaround two, execute the repair script and let MySQL fix it yourself. The mysql_fix_privilege_tables.sql in the share directory is the repair script, which is also executed.

Use MySQL;

SOURCE Mysql_fix_privilege_tables.sql;

Flush privileges;

Cause: This problem occurs because of inconsistencies caused by version upgrades.

MySQL's workaround for "Table ' mysql.servers ' doesn ' t exist"