MySQL5.7 启动报错:initialize specified but the data directory has files in it. Aborting.
来源:互联网 发布:淘宝上货助手 编辑:程序博客网 时间:2024/06/16 04:22
刚安装好的MySQL5.7.12,执行service mysqld start时报错,内容如下:
2017-02-19T07:52:53.807647Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2017-02-19T07:52:53.809065Z 0 [ERROR] –initialize specified but the data directory has files in it. Aborting.
2017-02-19T07:52:53.809095Z 0 [ERROR] Aborting
其中红色字体里面说明,mysql中的data目录已经有数据了,解决方案:
vim /etc/my.cnf,
datadir=/var/lib/mysql, 这个是data保存目录,进入/var/lib/mysql后,查看到确实有数据:
将/var/lib/mysql备份,然后重新启动mysql:
0 0
- MySQL5.7 启动报错:initialize specified but the data directory has files in it. Aborting.
- mysql报错:--initialize specified but the data directory has files in it. Aborting.
- --initialize specified but the data directory has files in it. Aborting
- MyEclipse报错:It appears that the Web Project,“”,has no Web Root directory setup
- Dataguard DBLOG FILE NAME CONVERT has been set but files are created in a different directory (文档 ID
- The goal you specified requires a project to execute but there is no POM in this directory
- The goal you specified requires a project to execute but there is no POM in this directory
- [ERROR] The goal you specified requires a project to execute but there is no POM in this directory
- The goal you specified requires a project to execute but there is no POM in this directory...
- [ERROR] The goal you specified requires a project to execute but there is no POM in this directory
- 系统报错:Error the user data image is used by another emulator. aborting
- 关于VS2003.NET的“The solution has more than 16384 VC files in it.”问题。
- A file with the correct name was found in this directory, but it is not the correct one.
- Adapter报错:The content of the adapter has changed but ListView did not receive a
- Adapter报错:The content of the adapter has changed but ListView did not receive a
- Adapter报错:The content of the adapter has changed but ListView did not receive a
- Info.plist文件报错,The data couldn’t be read because it isn’t in the correct format.
- Spark 启动历史任务记录进程,报错 Logging directory must be specified解决
- Javascript数据结构算法之栈(进制转换,阶乘,后缀表达式,括号匹配)
- sh 脚本打印log
- 等差数列应用——控制台输出沙漏
- Gym 101243 (2016-2017 ACM Central Region of Russia Quarterfinal Programming Contest)
- test
- MySQL5.7 启动报错:initialize specified but the data directory has files in it. Aborting.
- Android虚拟机——Dalvik/ART
- 推荐系统常用评测指标
- O
- matlab:inv,pinv逆与伪逆
- c++头文件
- nginx配置改变默认访问路径
- 安装时 error: INSTALL_FAILED_VERSION_DOWNGRADE
- 正则表达式常用匹配