1146 - Table 'performance_schema.session_variables' doesn't exist

1146 -Table 'performance_schema.session_variables'doesn't exist 2017-09-12 18:09:22 616人浏览无得

摘要

1146 - Table "perfORMance_schema.session_variables" doesn"t exist 一问题出现场景 1 在flask使用sqlAlchemy操作Mysql的时候会出现 2 使用N

1146 - Table "perfORMance_schema.session_variables" doesn"t exist

一问题出现场景

1 在flask使用sqlAlchemy操作Mysql的时候会出现

2 使用Navicat连接数据库会出现

附：连接Navicat成功的要点

(1) 需要用户有足够的权限
(2) mysql数据库默认不允许这些客户端工具进行连接，需要在/etc/mysql/mysql.conf.d/mysqld.cnf文件中的bind-address = 127.0.0.1改为：bind-address = 0.0.0.0，重启（我的是ubuntu环境）

二解决办法

mysql_upgrade -u root -p --force  # 升级修复MySQL数据库结构错误
sudo service mysql restart  # 重启

您可能感兴趣的文档:

--结束END--

本文标题: 1146 - Table 'performance_schema.session_variables' doesn't exist

本文链接: https://lsjlt.com/news/6067.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

猜你喜欢

1146 - Table 'performance_schema.session_variables' doesn't exist

1146 - Table "performance_schema.session_variables" doesn"t exist 一问题出现场景 1 在Flask使用SQLAlchemy操作mysql的时候会出现 2 使用N...

99+

2017-09-12

1146 - Table 'performance_schema.session_variables' doesn't exist
You can't specify target table 'Person' for update in FROM clause

DELETE FROM Persons WHERE Id NOT IN (SELECT MIN(Id)AS id FROM Persons GROUP BY Email) ; You can"t ...

99+

2016-03-28

You can't specify target table 'Person' for update in FROM clause
Navicat 1142 SELECT command denied to user 'sx'@'xxx' for table 'user' - G

Navicat 1142 SELECT command denied to user "sx"@"xxx" for table "user" 使用Navicat使用sx用户连接数据库时或者连接为用户sx开放的数据库travel...

99+

2019-12-02

Navicat 1142 SELECT command denied to user 'sx'@'xxx' for table 'user' - G
update mysql row (You can't specify target table 'x' for update in FROM clause)

sql语句(update/delete都会出现此问题) update x set available_material_id = null where id not in (select id from x wher&#...

99+

2018-03-17

update mysql row (You can't specify target table 'x' for update in FROM clause)
ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2)

系统因为突然断电，导致查询mysql数据时老是失败。报ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2)这个错误。 ...

99+

2024-04-02
mysql报Can't create/write to file '/tmp/ib0n3frL' (Errcode: 13 - Permission denied)

初始化数据库报错[root@Master mysql-5.6.24]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/u...

99+

2024-04-02
Can't connect to local MySQL through socket '/tmp/mysql.sock'解决方法

报错信息： ERROR 2002: Can't connect to local MySQL server through socket ‘/tmp/mysql.sock' (111) 解决办法： ...

99+

2024-04-02
MySQL问题记录——2003-Can't connect to MySQL server on 'localhost'(10038)

MySQL问题记录——2003-Can"t connect to MySQL server on "localhost"(10038) 摘要：本文主要记录了连接到MySQL数据库时出现的问题以及解决办法。问题重现在使用Navicat连接...

99+

2014-06-05

MySQL问题记录——2003-Can't connect to MySQL server on 'localhost'(10038)
Can't connect to MySQL server on 'localhost' (10048)问题解决方法

解决Can't connect to MySQL server on 'localhost' (10048), 一般见于使用mysql的windows 2003服务器. 错误的出现的...

99+

2022-11-15

connect MySQL 10048
Mysql:The user specified as a definer ('xxx@'%') does not exist的解决方案

今天项目优化过程中，mysql有个问题The user specified as a definer ('wx_root'@'%') does not exist 查了一下，意思是执行sql无权限。 &nb...

99+

2024-04-02
[MySQL] BLOB, TEXT, GEOMETRY or JSON column 'body' can't have a default value错误

mysql严格模式下 , 不允许给blob text geomtry json列增加默认值可以使用 select @@sql_mode 查看当前模式 , 例如下面这样 mysql> select @@sql_mode -...

99+

2021-11-30

[MySQL] BLOB TEXT GEOMETRY or JSON column 'body' can't have a default value错误
mysql初始化错误【一】Can't find error-message file '/usr/local/mysql/errmsg.sys'

环境：CentOS 7.2 MySQL 5.7.18 从mysql官方网站下载rpm包到服务器本地，依次安装下面的RPM包：&...

99+

2024-04-02
解决MySQL启动报错:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

这个错误是新手经常会遇到的，本文主要介绍如何修复ERROR 2003 (HY000): Can't connect to MySQL server on ‘localhost' (10061) 解决方案: 1、登录到...

99+

2022-05-14

MySQL报错:ERROR 2003 (HY000): Can''t connect to MySQL server on ''localhost'' (10061) 解决MySQL ERROR 20
lower_case_table_names参数设置解决Error Code: 1146. Table doesn't exist?

在 MariaDB 10.2.11 for windows中使用mysqldump导出DB，并导入Mysql 5.7.16 for Linux后，在程式执行时报错：Error Code:...

99+

2024-04-02
Table '' is marked as crashed and should be repaired 解决方法

解决方法：找到mysql的安装目录的bin/myisamchk工具，在命令行中输入：myisamchk -c -r ../data/mysql/user.MYI然后myisam...

99+

2024-04-02
install xshell，xftp <You can't access this shared folder because your organization's

You can‘t access this shared folder because your organization‘s security policies block unauthenticated guest access. Th...

99+

2019-10-24

install xshell，xftp <You can't access this shared folder because your organization's
js报错 Object doesn't support this property or method的原因分析

js报错： Object doesn't support this property or method 问题原因： 1：js代码用了javascript关键字 2：方法名和表单或者...

99+

2022-11-21

Object support
MySQL查询报错：ERROR 1146 (42S02): Table 'craw.sitePageConfig' doesn't exist

今天一同事咨询mysql的问题，在mysql主库访问某个表报错，但是备库上可以，感觉有点奇怪。即使不同步，也不能说主库不能访问啊。既然是主备，...

99+

2024-04-02
install xshell，xftp <You can't access this shared folder because your organization's se

原文：https://www.cnblogs.com/morganh/p/13963373.html...

99+

2015-04-20

install xshell，xftp <You can't access this shared folder because your organization's se
T-SQL格式化工具 Poor Man's T

　　在平时开工作发中，当遇到 SQL 语句格式混乱、字段又比较多的时候，真是让人狂抓！　　幸好，最近发现了一款好用的T-SQL格式化工具：Poor Man"s T-SQL Formatter。该工具用于格式化SQL语句，具有简单...

99+

2014-12-01

T-SQL格式化工具 Poor Man's T