flush privileges提示Table 'mysql.servers' doesn't exist解决办法
来源:互联网 发布:餐饮如何分析营业数据 编辑:程序博客网 时间:2024/05/13 22:40
mysql root设置密码以及flush privileges提示Table 'mysql.servers' doesn't exist解决办法
mysql设置密码:
mysql>use mysql
mysql> update user set password=password('3660207q') where user='root';
mysql> flush privileges;
mysql> quit ;
mysql当执行flush privileges刷新用户权限命令报出ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
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';
mysql> flush privileges;
mysql设置密码:
mysql>use mysql
mysql> update user set password=password('3660207q') where user='root';
mysql> flush privileges;
mysql> quit ;
mysql当执行flush privileges刷新用户权限命令报出ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
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';
mysql> flush privileges;
阅读全文
0 0
- flush privileges提示Table 'mysql.servers' doesn't exist解决办法
- Mysql “Table 'mysql.servers' doesn't exist”
- Mysql的“Table 'mysql.servers' doesn't exist”的解决方法
- Mysql的“Table 'mysql.servers' doesn't exist”的解决方法
- Mysql的“Table 'mysql.servers' doesn't exist”的解决方法
- Mysql table '' doesn`t exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- Mysql最后一步安装错误,Error Nr.1146 Table 'mysql.servers' doesn't exist
- 数据库备份 Mysql table '' doesn`t exist
- mysql Table 'performance_schema.session_variables' doesn't exist
- mysql Table 'performance_schema.session_status' doesn't exist
- Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist mysql
- table 'mysql.proc' doesn't exist问题解决
- mysql新建表时提示Table 'db.table' doesn't exist解决方法
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解决办法
- net start mysql提示服务无法启动 MySQL: Table 'mysql.plugin' doesn't exist
- Table'mysql.proc' doesn't exist和Table 'mysql.event'doesn't exist警告
- com.alibaba.druid.sql.parser.ParserException: syntax error,expect IS, actual EQ id
- php基于laravel框架的批量插入操作
- 作业10.17
- java方法调用中的单分派与多分派
- java定时任务Timer,Quartz
- flush privileges提示Table 'mysql.servers' doesn't exist解决办法
- kurento 6.6.0 安装部署 + 运行官网demo
- html布局
- 【杨辉三角】
- 纯CSS写的加载动画--圆球搜索加载动画
- 2017-10-15练习题
- Android RxActivityResult:优雅的方式实现startActivityForResult
- uva11809 紫书第三章习题
- NOIP专题复习(一) 基础的背包问题