各种游戏汇总

mysql 重启报错,重启失败。

PHPer 2025-10-06 3 0 0
2025-10-06T08:27:04.914780Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2025-10-06T08:27:04.914979Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-10-06T08:27:04.914987Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2025-10-06T08:27:04.915012Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2025-10-06T08:27:04.915041Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 85559 ...
2025-10-06T08:27:04.919351Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2025-10-06T08:27:04.934818Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-10-06T08:27:04.934870Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-10-06T08:27:04.934876Z 0 [Note] InnoDB: Uses event mutexes
2025-10-06T08:27:04.934879Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-10-06T08:27:04.934885Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-10-06T08:27:04.935330Z 0 [Note] InnoDB: Number of pools: 1
2025-10-06T08:27:04.935444Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-10-06T08:27:04.936628Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2025-10-06T08:27:04.992772Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-10-06T08:27:05.010105Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-10-06T08:27:05.023372Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-10-06T08:27:05.044447Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-10-06T08:27:05.044529Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-10-06T08:27:05.087963Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2025-10-06T08:27:05.089303Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-10-06T08:27:05.089329Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-10-06T08:27:05.090158Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 2811868
2025-10-06T08:27:05.090369Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2025-10-06T08:27:05.090584Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251006 16:27:05
2025-10-06T08:27:05.090636Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2025-10-06T08:27:05.090833Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2025-10-06T08:27:05.091488Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-10-06T08:27:05.093354Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-10-06T08:27:05.093377Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-10-06T08:27:05.093385Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-10-06T08:27:05.093388Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-10-06T08:27:05.093973Z 0 [Warning] CA certificate ca.pem is self signed.
2025-10-06T08:27:05.094011Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2025-10-06T08:27:05.094084Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2025-10-06T08:27:05.094128Z 0 [Note] IPv6 is available.
2025-10-06T08:27:05.094134Z 0 [Note]   - '::' resolves to '::';
2025-10-06T08:27:05.094153Z 0 [Note] Server socket created on IP: '::'.
2025-10-06T08:27:05.096829Z 0 [Warning] Failed to open optimizer cost constant tables

2025-10-06T08:27:05.096982Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2025-10-06T08:27:05.097013Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2025-10-06T08:27:05.097091Z 0 [ERROR] Aborting

2025-10-06T08:27:05.097118Z 0 [Note] Binlog end
2025-10-06T08:27:05.097186Z 0 [Note] Shutting down plugin 'ngram'
2025-10-06T08:27:05.097193Z 0 [Note] Shutting down plugin 'partition'
2025-10-06T08:27:05.097197Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2025-10-06T08:27:05.097200Z 0 [Note] Shutting down plugin 'ARCHIVE'
2025-10-06T08:27:05.097203Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-10-06T08:27:05.097257Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2025-10-06T08:27:05.097260Z 0 [Note] Shutting down plugin 'MyISAM'
2025-10-06T08:27:05.097275Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2025-10-06T08:27:05.097279Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2025-10-06T08:27:05.097282Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2025-10-06T08:27:05.097285Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2025-10-06T08:27:05.097288Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2025-10-06T08:27:05.097290Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2025-10-06T08:27:05.097293Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2025-10-06T08:27:05.097296Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2025-10-06T08:27:05.097299Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2025-10-06T08:27:05.097301Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2025-10-06T08:27:05.097304Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2025-10-06T08:27:05.097307Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2025-10-06T08:27:05.097310Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2025-10-06T08:27:05.097312Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2025-10-06T08:27:05.097315Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2025-10-06T08:27:05.097317Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2025-10-06T08:27:05.097320Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2025-10-06T08:27:05.097323Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2025-10-06T08:27:05.097325Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2025-10-06T08:27:05.097328Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2025-10-06T08:27:05.097330Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2025-10-06T08:27:05.097333Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2025-10-06T08:27:05.097336Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-10-06T08:27:05.097338Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2025-10-06T08:27:05.097341Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2025-10-06T08:27:05.097344Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2025-10-06T08:27:05.097347Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2025-10-06T08:27:05.097349Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2025-10-06T08:27:05.097352Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2025-10-06T08:27:05.097355Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2025-10-06T08:27:05.097357Z 0 [Note] Shutting down plugin 'InnoDB'
2025-10-06T08:27:05.097468Z 0 [Note] InnoDB: FTS optimize thread exiting.
2025-10-06T08:27:05.097606Z 0 [Note] InnoDB: Starting shutdown...
2025-10-06T08:27:05.198024Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2025-10-06T08:27:05.198252Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 251006 16:27:05
2025-10-06T08:27:06.512887Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2811887
2025-10-06T08:27:06.514962Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2025-10-06T08:27:06.514993Z 0 [Note] Shutting down plugin 'MEMORY'
2025-10-06T08:27:06.515000Z 0 [Note] Shutting down plugin 'CSV'
2025-10-06T08:27:06.515004Z 0 [Note] Shutting down plugin 'sha256_password'
2025-10-06T08:27:06.515006Z 0 [Note] Shutting down plugin 'mysql_native_password'
2025-10-06T08:27:06.515148Z 0 [Note] Shutting down plugin 'binlog'
2025-10-06T08:27:06.516999Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

20251006 1628 ...

立即注册
更新于:2025-10-06 16:29:00
    您需要登录后才可以评论。 立即注册
    相关内容

    XAMPP的mysql启动失败:Plugin 'FEEDBACK' is disabled.

    xammp 启动mysql报错Error: MySQL shutdown unexpectedly. This may be d...

    阿里云服务器控制台端重启速度很慢要十几分钟

    php报错 Error: Variable 'sql_mode' can't be set to the value of 'M...

    mysql在导入大数据库的时候,报错 Unknown MySQL server host ... ER...

    Mysql问题整理

    Yii2数据库报错-SQLSTATE[HY093]: Invalid parameter number: no para...

    Mysql server has gone away 报错原因分析及解决办法

    mysql 警告 could not be resolved: Name or service not known

    Mysql用特殊字符设置密码遇到的问题

    Mysql的函数substring使用注意事项

    MySQL 5.7内存使用分析

    mysql 命令整理

    【mysql】主键、普通索引、唯一索引和全文索引的比较

    没有接收到要导入的数据。可能是文件名没有提交,也可能是文件大小超出 PHP 限...

    Mysql 报错'SQLSTATE[HY000] [1045] Access denied for user 'root'@'...

    php连接mysql报错The server requested authentication method unknown to ...

    Mysql登录提示ERROR 2003 (HY000): Can't connect to MySQL server o...

    Mysql报错SQLSTATE[HY000]: General error: 1366 Incorrect string ...

    全网最详尽的Centos和Windows系统 Mysql8 root忘记密码解决办法

    mysql数据库操作 报错 #1030 - Got error 176 "Read page with wrong ...

    Linux系统彻底卸载MySQL数据库

    Linux下mysql5.7忘记root密码的解决方法

    ERROR 1130 (HY000): Host '127.0.0.1' is not allowed to connect to...

    mysql创建数据类型为JSON时,显示的longtext数据类型

    mysql 修改编码utf8mb4依旧无法保存表情 Incorrect string value: '\x解决办法

    MySQL 中 不等于 会过滤掉 Null 的问题

    RECOVER_YOUR_DATA勒索恢复

    推荐内容

    怎样使用V2Ray代理和SSTap玩如魔兽世界/绝地求生/LOL台服/战地3/黑色沙漠/彩...

    sstap游戏代理教程 从此玩如魔兽世界/绝地求生/LOL台服/战地3/黑色沙漠/彩虹六...

    BT磁力搜索网站汇总和找不到的资源

    什么是磁力链接,您如何使用?

    Z-Library:全球最大的数字图书馆/含打不开的解决方案/镜像

    使用V2Ray的mKCP协议加速游戏

    v2rayN已停止工作

    【车险课堂】什么是无赔款优待系数ncd,你“造”吗?