Mysql executes the flushprivileges command with the error ERROR1146 (42S02): Tab

When mysql executes the flushprivileges refresh user permission command, the following error is reported: ERROR1146 (42S02): Tablemysql. serversdoesntexist is a false test, which literally means mysql. if servers does not exist, you can directly create one. The SQL statement is as follows: copy and paste it to the command line: CREATETABLE 'serv

When mysql executes the flush privileges refresh user permission command, the ERROR 1146 (42S02): Table 'mysql. servers 'doesn' t exist, which literally means mysql. if servers does not exist, you can directly CREATE one. The SQL statement is as follows: copy and paste it to the command line: CREATE TABLE 'serv

When mysql executes the flush privileges refresh user permission command, the ERROR 1146 (42S02): Table 'mysql. servers 'doesn' t exist, which literally means mysql. if servers does not exist, you can directly create one. The SQL statement is as follows. copy and paste it to the command line:

CREATE TABLE `servers` (`Server_name` char(64) NOT NULL,`Host` char(64) NOT NULL,`Db` char(64) NOT NULL,`Username` char(64) NOT NULL,`Password` char(64) NOT NULL,`Port` int(4) DEFAULT NULL,`Socket` char(64) DEFAULT NULL,`Wrapper` char(64) NOT NULL,`Owner` char(64) NOT NULL,PRIMARY KEY (`Server_name`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

Run the flush privileges command.

Original article address: mysql executes the flush privileges command to hold ERROR 1146 (42S02): Tab. Thank you for sharing it.