mysqld --initialize出错

qq_33265192 2017-06-05 08:50:51
我在配置mysql的时候再这一步出错:D:\Program Files\MySQL\MySQL Server\bin>mysqld --initialize
2017-06-05T12:37:16.438600Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is
deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
2017-06-05T12:37:16.438600Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E
RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will
be merged with strict mode in a future release.
2017-06-05T12:37:16.438600Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not s
et.
2017-06-05T12:37:16.449600Z 0 [ERROR] Can't read from messagefile 'd:\163dz\mysq
l\share\english\errmsg.sys'
2017-06-05T12:37:16.455600Z 0 [ERROR] --initialize specified but the data direct
ory has files in it. Aborting.
2017-06-05T12:37:16.456600Z 0 [ERROR] Aborting
这里的d:\163dz\mysq
l\share\english\errmsg.sys'这个路径是我在使用的一个软件也是有的是这个数据库类型。求解怎么处理??
...全文
1786 2 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_33265192 2017-06-06
  • 打赏
  • 举报
回复
没有人帮我么?我是完全菜鸟啊!
qq_33265192 2017-06-05
  • 打赏
  • 举报
回复
使用这个检查出现如下: D:\Program Files\MySQL\MySQL Server\bin>mysqld --console 2017-06-05T12:54:17.693600Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2017-06-05T12:54:17.694600Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-06-05T12:54:17.694600Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not s et. 2017-06-05T12:54:17.694600Z 0 [Note] --secure-file-priv is set to NULL. Operatio ns related to importing and exporting data are disabled 2017-06-05T12:54:17.694600Z 0 [Note] mysqld (mysqld 5.7.18) starting as process 29996 ... 2017-06-05T12:54:17.696600Z 0 [ERROR] Can't read from messagefile 'd:\163dz\mysq l\share\english\errmsg.sys' 2017-06-05T12:54:17.700600Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2017-06-05T12:54:17.701600Z 0 [Note] InnoDB: Uses event mutexes 2017-06-05T12:54:17.701600Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2017-06-05T12:54:17.701600Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-06-05T12:54:17.702600Z 0 [Note] InnoDB: Number of pools: 1 2017-06-05T12:54:17.702600Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2017-06-05T12:54:17.704600Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M 2017-06-05T12:54:17.714600Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-06-05T12:54:17.727600Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat a1' must be writable 2017-06-05T12:54:17.728600Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat a1' must be writable 2017-06-05T12:54:17.728600Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2017-06-05T12:54:18.028600Z 0 [ERROR] Plugin 'InnoDB' init function returned err or. 2017-06-05T12:54:18.028600Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-06-05T12:54:18.028600Z 0 [ERROR] Failed to initialize plugins. 2017-06-05T12:54:18.029600Z 0 [ERROR] Aborting 2017-06-05T12:54:18.029600Z 0 [Note] Binlog end 2017-06-05T12:54:18.029600Z 0 [Note] Shutting down plugin 'CSV' 2017-06-05T12:54:18.030600Z 0 [Note] 我认为问题就出在:d:\163D这个软件的路径上了,怎么解决这个问题,这个软件是要经常使用的不能卸载。

672

社区成员

发帖
与我相关
我的任务
社区描述
提出问题
其他 技术论坛(原bbs)
社区管理员
  • community_281
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧