mysql 'performance_schema'.'session_variables' 问题处理
来源:互联网 发布:淘宝小二布置作业短信 编辑:程序博客网 时间:2024/05/21 17:21
今天,升级了mysql 5.7,使用mysql-workbench时,处理问题,无法连接mysql服务了。
先提示’performance_schema’.’session_variables’不存在,后来提示结构错误:
mysql-workbench Connecting to MySQL server ... Native table 'performance_schema'.'session_variables' has the wrong structure
执行操作:
1.输入:mysql_upgrade -uroot -p
2.重启mysql服务:mysql.service restart
然后就操作正常了。
0 0
- mysql 'performance_schema'.'session_variables' 问题处理
- mysql 'performance_schema'.'session_variables' 问题处理
- mysql Table 'performance_schema.session_variables' doesn't exist
- 【笔记】mysql Table 'performance_schema.session_variables' doesn't exist
- mysql error:Table 'performance_schema.session_variables' doesn't exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- java连接mysql、 Table 'performance_schema.session_variables' doesn't exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- Mysql Native table 'performance_schema'.'session_variables' has the wrong structure
- 解决Table 'performance_schema.session_variables' doesn't exist问题
- mysql 操作 远程访问 错误:mysql Table 'performance_schema.session_variables' doesn't exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist 解决的方法是:
- 关于连接myEclipse连接mysql时出现 Table 'performance_schema.session_variables' doesn't exist错误解决方法
- Mysql 升级重装后连接出错 Table \'performance_schema.session_variables\' doesn\'t exist
- Table ‘performance_schema.session_variables’ doesn’t exist
- Table 'performance_schema.session_variables' doesn't exist
- Table ‘performance_schema.session_variables’ doesn’t exist
- Table 'performance_schema.session_variables' doesn't exist.
- js之数组,对象,类数组对象
- android和ios GoogleMap画导航线路图 路径规划(Directions)
- (POJ 1724)ROADS <DFS + 简单剪枝>
- iMessage 扩展开发调试的时候
- Sublime Text install package
- mysql 'performance_schema'.'session_variables' 问题处理
- yum国内镜像配置
- win7下caffe的编译(包括caffe_python接口配置)以及python27下numpy、matplotlib、scipy等的安装
- Android Animation动画总结
- 快速多目标检测——YOLO9000
- JavaBeans规范
- 推荐系统中的SVD算法
- java基础的集合图
- ActiveMQ讯息传送机制以及ACK机制