MySQL 问题汇总

ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist

执行以下 SQL 语句删除并重新创建 mysql.servers 表

USE mysql
DROP TABLE IF EXISTS servers;
CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL Foreign Servers table';
CREATE USER report01@'192.168.100.20';
GRANT SELECT ON *.* TO 'report02'@'192.168.100.20' IDENTIFIED BY "Password";
FLUSH PRIVILEGES;

USE mysql

DROP TABLE IF EXISTS servers;

CREATE TABLE `servers` (

`Server_name` char(64) NOT NULL DEFAULT '',

`Host` char(64) NOT NULL DEFAULT '',

`Db` char(64) NOT NULL DEFAULT '',

`Username` char(64) NOT NULL DEFAULT '',

`Password` char(64) NOT NULL DEFAULT '',

`Port` int(4) NOT NULL DEFAULT '0',

`Socket` char(64) NOT NULL DEFAULT '',

`Wrapper` char(64) NOT NULL DEFAULT '',

`Owner` char(64) NOT NULL DEFAULT '',

PRIMARY KEY (`Server_name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL Foreign Servers table';

CREATE USER report01@'192.168.100.20';

GRANT SELECT ON *.* TO 'report02'@'192.168.100.20' IDENTIFIED BY "Password";

FLUSH PRIVILEGES;

文章出自: 本站技术文章均为原创，版权归 "Desen往事 - 个人博客" 所有；部分图片来源于 Yandex ，转载本站文章请注明来源。

本文标题：MySQL 问题汇总

本文链接：http://www.desenpast.com/databases/mysql-5263.html

Desen往事

简单生活，知足常乐

发表评论取消回复

相关文章

发表评论 取消回复

发表评论取消回复