版本:5.7.11, 5.7.18
mysql> flush privileges;
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
mysql> use mysql;
Database changed
mysql>drop table if exists servers;
mysql> 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';
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
?在第一次登陆修改密码后set password=password('mysql');创建该表提示错误:ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist??
?重启mysql后再次执行创建表的语句就可以了,不知道是什么原因。
阅读(1554) | 评论(0) | 转发(0) |