MySql：ERROR 1130--后端、前端、移动开发、大数据、Java、Python、Vue开发经验分享

MySql：ERROR 1130

mysql密码忘记（ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using ）
一.ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)如上，为密码不正确操作步骤：service mysqld stop 编辑/etc/my.cnf 在[mysqld]下加入skip-grant-tables，重启mysql服务可以直接登录检查a
日期 2023-06-12 10:48:40
Mysql报错[ERROR] InnoDB: Operating system error number 87 in a fil
彻底放弃了Windows11 昨晚格盘重装Windows10，秉承着本地环境可以不用，但是不能没有的原则还是装了一下用过很久很久的PHPenvwtm，mysql跑不起，排查log2023-01-04T11:02:14.418303+08:00 0 [Note] --secure-file-priv is set to NULL. Operations related to importing an
日期 2023-06-12 10:48:40
图文结合带你搞懂MySQL日志之Error Log（错误日志）
* GreatSQL社区原创内容未经授权不得随意使用，转载请联系小编并注明来源。往期回顾：图文结合带你搞懂MySQL日志之Redo Log(重做日志) 图文结合带你搞懂InnoDB MVCC 图文结合带你搞定MySQL日志之Undo log(回滚日志) 什么是错误日志错误日志（Error Log）是 MySQL 中最常用的一种日志，主要记录 MySQL 服务器启动和停止过程中的信息、服务器在运行
日期 2023-06-12 10:48:40
MySql Host is blocked because of many connection errors； unblock with ‘mysqladmin flush-hosts‘ 解决方法
文章目录1、问题描述2、分析3、解决办法1、问题描述数据库远程连接的时候出现下列错误： blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ 2、分析这是因为在短时间内产生大量中断的数据库连接从而导致阻塞。3、解决办法找到mysqladmin linux中运行whereis mysqla
日期 2023-06-12 10:48:40
MySQL Error number: 1887; Symbol: WARN_NAMED_PIPE_ACCESS_EVERYONE; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 1887; Symbol: WARN_NAMED_PIPE_ACCESS_EVERYONE; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 1887; Symbol: WARN_NAMED_PIPE_ACCESS_EVERYONE; SQLSTATE: HY000 Message: Setting
日期 2023-06-12 10:48:40
MySQL Error number: 3003; Symbol: ER_STORAGE_ENGINE_NOT_LOADED; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3003; Symbol: ER_STORAGE_ENGINE_NOT_LOADED; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3003; Symbol: ER_STORAGE_ENGINE_NOT_LOADED; SQLSTATE: HY000 Message: Storage engin
日期 2023-06-12 10:48:40
MySQL Error number: 3006; Symbol: ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3006; Symbol: ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3006; Symbol: ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN; SQLSTATE: HY000 Message: State
日期 2023-06-12 10:48:40
MySQL Error number: 3013; Symbol: ER_INVALID_FIELD_SIZE; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3013; Symbol: ER_INVALID_FIELD_SIZE; SQLSTATE: HY000 报错故障修复远程处理 Error number: 3013; Symbol: ER_INVALID_FIELD_SIZE; SQLSTATE: HY000 Message: Invalid size for column %s . Er
日期 2023-06-12 10:48:40
MySQL Error number: 3016; Symbol: ER_PASSWORD_EXPIRE_ANONYMOUS_USER; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3016; Symbol: ER_PASSWORD_EXPIRE_ANONYMOUS_USER; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3016; Symbol: ER_PASSWORD_EXPIRE_ANONYMOUS_USER; SQLSTATE: HY000 Message: The
日期 2023-06-12 10:48:40
MySQL Error number: 3021; Symbol: ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3021; Symbol: ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3021; Symbol: ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP; SQLSTATE: HY000 Messag
日期 2023-06-12 10:48:40
MySQL Error number: 3022; Symbol: ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3022; Symbol: ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3022; Symbol: ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO; SQLSTATE: HY000 Mess
日期 2023-06-12 10:48:40
MySQL Error number: 3023; Symbol: ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3023; Symbol: ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3023; Symbol: ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS; SQLSTATE: HY000 Message:
日期 2023-06-12 10:48:40
MySQL Error number: 3031; Symbol: ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3031; Symbol: ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3031; Symbol: ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER; SQLSTATE:
日期 2023-06-12 10:48:40
MySQL Error number: 3032; Symbol: ER_SERVER_OFFLINE_MODE; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3032; Symbol: ER_SERVER_OFFLINE_MODE; SQLSTATE: HY000 报错故障修复远程处理 Error number: 3032; Symbol: ER_SERVER_OFFLINE_MODE; SQLSTATE: HY000 Message: The server is currently in offli
日期 2023-06-12 10:48:40
MySQL Error number: 3040; Symbol: ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3040; Symbol: ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3040; Symbol: ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTIO
日期 2023-06-12 10:48:40
MySQL Error number: 3045; Symbol: ER_STD_DOMAIN_ERROR; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3045; Symbol: ER_STD_DOMAIN_ERROR; SQLSTATE: HY000 报错故障修复远程处理 Error number: 3045; Symbol: ER_STD_DOMAIN_ERROR; SQLSTATE: HY000 Message: Domain error: %s in function %s. 错误
日期 2023-06-12 10:48:40
MySQL Error number: 3052; Symbol: ER_STD_LOGIC_ERROR; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3052; Symbol: ER_STD_LOGIC_ERROR; SQLSTATE: HY000 报错故障修复远程处理 Error number: 3052; Symbol: ER_STD_LOGIC_ERROR; SQLSTATE: HY000 Message: Logic error: %s in function %s. 错误说明：
日期 2023-06-12 10:48:40
MySQL Error number: 3055; Symbol: ER_GIS_DATA_WRONG_ENDIANESS; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3055; Symbol: ER_GIS_DATA_WRONG_ENDIANESS; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3055; Symbol: ER_GIS_DATA_WRONG_ENDIANESS; SQLSTATE: HY000 Message: Geometry byte s
日期 2023-06-12 10:48:40
MySQL Error number: 3067; Symbol: ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3067; Symbol: ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3067; Symbol: ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN; SQLSTATE: HY000
日期 2023-06-12 10:48:40
MySQL Error number: 3069; Symbol: ER_INVALID_JSON_DATA; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3069; Symbol: ER_INVALID_JSON_DATA; SQLSTATE: HY000 报错故障修复远程处理 Error number: 3069; Symbol: ER_INVALID_JSON_DATA; SQLSTATE: HY000 Message: Invalid JSON data provided to functi
日期 2023-06-12 10:48:40
MySQL Error number: 3071; Symbol: ER_INVALID_GEOJSON_WRONG_TYPE; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3071; Symbol: ER_INVALID_GEOJSON_WRONG_TYPE; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3071; Symbol: ER_INVALID_GEOJSON_WRONG_TYPE; SQLSTATE: HY000 Message: Invalid Geo
日期 2023-06-12 10:48:40
MySQL Error number: 3076; Symbol: ER_SLAVE_CHANNEL_NAME_INVALID_OR_TOO_LONG; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3076; Symbol: ER_SLAVE_CHANNEL_NAME_INVALID_OR_TOO_LONG; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3076; Symbol: ER_SLAVE_CHANNEL_NAME_INVALID_OR_TOO_LONG; SQLSTATE: HY0
日期 2023-06-12 10:48:40
MySQL Error number: 3077; Symbol: ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3077; Symbol: ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3077; Symbol: ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY; SQLSTATE: HY000 Mess
日期 2023-06-12 10:48:40
MySQL Error number: 3084; Symbol: ER_SLAVE_CHANNEL_WAS_NOT_RUNNING; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3084; Symbol: ER_SLAVE_CHANNEL_WAS_NOT_RUNNING; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3084; Symbol: ER_SLAVE_CHANNEL_WAS_NOT_RUNNING; SQLSTATE: HY000 Message: Repli
日期 2023-06-12 10:48:40
MySQL Error number: 3087; Symbol: ER_WRONG_FIELD_WITH_GROUP_V2; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3087; Symbol: ER_WRONG_FIELD_WITH_GROUP_V2; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3087; Symbol: ER_WRONG_FIELD_WITH_GROUP_V2; SQLSTATE: HY000 Message: Expression #%
日期 2023-06-12 10:48:40
MySQL Error number: 3094; Symbol: ER_GROUP_REPLICATION_APPLIER_INIT_ERROR; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3094; Symbol: ER_GROUP_REPLICATION_APPLIER_INIT_ERROR; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3094; Symbol: ER_GROUP_REPLICATION_APPLIER_INIT_ERROR; SQLSTATE: HY000
日期 2023-06-12 10:48:40
MySQL Error number: 3095; Symbol: ER_GROUP_REPLICATION_STOP_APPLIER_THREAD_TIMEOUT; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3095; Symbol: ER_GROUP_REPLICATION_STOP_APPLIER_THREAD_TIMEOUT; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3095; Symbol: ER_GROUP_REPLICATION_STOP_APPLIER_THREAD_TIMEOUT;
日期 2023-06-12 10:48:40
MySQL Error number: 3099; Symbol: ER_PREVENTS_VARIABLE_WITHOUT_RBR; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3099; Symbol: ER_PREVENTS_VARIABLE_WITHOUT_RBR; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3099; Symbol: ER_PREVENTS_VARIABLE_WITHOUT_RBR; SQLSTATE: HY000 Message: Canno
日期 2023-06-12 10:48:40
MySQL Error number: 3101; Symbol: ER_TRANSACTION_ROLLBACK_DURING_COMMIT; SQLSTATE: 40000 报错故障修复远程处理
MySQL Error number: 3101; Symbol: ER_TRANSACTION_ROLLBACK_DURING_COMMIT; SQLSTATE: 40000 报错故障修复远程处理文档解释 Error number: 3101; Symbol: ER_TRANSACTION_ROLLBACK_DURING_COMMIT; SQLSTATE: 40000 Mess
日期 2023-06-12 10:48:40
MySQL Error number: 3103; Symbol: ER_UNSUPPORTED_ALTER_INPLACE_ON_VIRTUAL_COLUMN; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3103; Symbol: ER_UNSUPPORTED_ALTER_INPLACE_ON_VIRTUAL_COLUMN; SQLSTATE: HY000 报错故障修复远程处理文档解释 Error number: 3103; Symbol: ER_UNSUPPORTED_ALTER_INPLACE_ON_VIRTUAL_COLUMN; SQL
日期 2023-06-12 10:48:40
MySQL Error number: 3110; Symbol: ER_FEATURE_NOT_AVAILABLE; SQLSTATE: HY000 报错故障修复远程处理
MySQL Error number: 3110; Symbol: ER_FEATURE_NOT_AVAILABLE; SQLSTATE: HY000 报错故障修复远程处理 Error number: 3110; Symbol: ER_FEATURE_NOT_AVAILABLE; SQLSTATE: HY000 Message: The %s feature is not availa
日期 2023-06-12 10:48:40