Table 'mysql. servers' doesn' t exist and not allowed to conne

Table 'mysql. servers 'doesn' t exist and not allowed to connect to MySQL server solve the problem of installing wamp at home today. After installing wamp, the default mysql root Password is blank. After changing the password flush privileges, the system prompts: ERROR 1146 (42S02): Table 'mysql. servers 'doesn' t exist solution: Create mysql. servers TABLE: create table mysql. 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 NUL L, 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 '; then flush privileges; succeeded. However, when you exit and log on again, the ERROR 1130 (HY000 ): host 'localhost' is not allowed to connect to this MySQL server solution: in mysql. add the skip-grant-tables row to ini and save the settings. Net stop wampmysqldnet start wampmysqld mysql-u root login, modify update mysql. user set password = password ('000000') where user = 'root' and host = 'localhost'; flush privileges; replace mysql. delete the skip-grant-tables line in ini, OK, and solve the problem. The problem is found later. When you change the root password, use the update mysql Command carelessly. user set password = md5 ('20140901') where user = 'root' and host = 'localhost'; the logon fails.