当前位置:论坛首页 > Linux面板 > 求助

mysql无法启动

发表在 Linux面板2018-4-13 15:51 [复制链接] 4 2309

2018-04-13T06:16:06.010193Z 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.
2018-04-13T06:16:08.388997Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-13T06:16:08.501001Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-04-13T06:16:08.501075Z 0 [ERROR] Aborting
2018-04-13T07:28:25.084323Z 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.
2018-04-13T07:28:25.431682Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-13T07:28:25.446595Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-04-13T07:28:25.446674Z 0 [ERROR] Aborting
2018-04-13T07:28:40.120693Z 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.
2018-04-13T07:28:40.355693Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-13T07:28:40.369201Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-04-13T07:28:40.369282Z 0 [ERROR] Aborting
2018-04-13T07:44:09.871854Z 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.
2018-04-13T07:44:12.448648Z 0 [ERROR] InnoDB: Cannot open '/www/server/data/ib_buffer_pool' for reading: No such file or directory
2018-04-13T07:44:12.457665Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-13T07:44:12.480477Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-04-13T07:44:12.480560Z 0 [ERROR] Aborting
==========================================================================================
mysql start error.
mysql无法正常启动,请将以上错误信息截图发至论坛寻求帮助


使用道具 举报 只看该作者 回复
发表于 2018-4-13 15:52:38 | 显示全部楼层
救命阿救命阿救命阿救命阿救命阿救命阿救命阿救命阿救命阿救命阿救命阿
使用道具 举报 回复 支持 反对
发表于 2018-4-13 16:11:56 | 显示全部楼层
什么mysql版本?
使用道具 举报 回复 支持 反对
发表于 2018-4-16 11:43:39 | 显示全部楼层

这是5.7的,哪个版本都试过,都无法启动,重装系统也这样,用 移动的云服务器
使用道具 举报 回复 支持 反对
发表于 2018-4-16 13:20:09 | 显示全部楼层
2018-04-16T05:19:19.336694Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2018-04-16T05:19:19.336823Z 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.
2018-04-16T05:19:19.336830Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-04-16T05:19:19.336852Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-04-16T05:19:19.336888Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.19-log) starting as process 8037 ...
2018-04-16T05:19:19.356644Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-04-16T05:19:19.356675Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16T05:19:19.356680Z 0 [Note] InnoDB: Uses event mutexes
2018-04-16T05:19:19.356684Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-04-16T05:19:19.356688Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-16T05:19:19.356693Z 0 [Note] InnoDB: Using Linux native AIO
2018-04-16T05:19:19.357067Z 0 [Note] InnoDB: Number of pools: 1
2018-04-16T05:19:19.357167Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16T05:19:19.358931Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2018-04-16T05:19:19.420512Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16T05:19:19.432214Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-04-16T05:19:19.442277Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2018-04-16T05:19:19.442298Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2018-04-16T05:19:19.442305Z 0 [ERROR] InnoDB: os_file_get_status() failed on '/www/server/data/ibdata1'. Can't determine file permissions
2018-04-16T05:19:19.442310Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-04-16T05:19:20.043249Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-04-16T05:19:20.043308Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-04-16T05:19:20.043322Z 0 [ERROR] Failed to initialize plugins.
2018-04-16T05:19:20.043328Z 0 [ERROR] Aborting

2018-04-16T05:19:20.043343Z 0 [Note] Binlog end
2018-04-16T05:19:20.043514Z 0 [Note] Shutting down plugin 'MyISAM'
2018-04-16T05:19:20.043545Z 0 [Note] Shutting down plugin 'CSV'
2018-04-16T05:19:20.044728Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

企业版年付运维跟进群

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急问题处理

论坛响应时间:10分钟

问题处理方式:1对1处理(优先)

工作时间:白班:9:00 - 18:00

工作时间:晚班:18:00 - 24:00

立即付费处理
快速回复 返回顶部 返回列表