windows10配置mysql失败
PHP中文网
PHP中文网 2017-04-17 13:32:12
0
2
849

各位大神看看下面是什么错误
以下是mysql启动日志:

mysqld: Can't change dir to 'D:\soft\mysql\mysql-5.7.10\data\' (Errcode: 2 - No such file or directory)
2015-12-09T03:10:18.851979Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-09T03:10:18.851979Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2015-12-09T03:10:18.852979Z 0 [Note] mysqld (mysqld 5.7.10) starting as process 5936 ...
2015-12-09T03:10:18.854968Z 0 [Warning] Can't create test file D:\soft\mysql\mysql-5.7.10\data\yzl021.lower-test
2015-12-09T03:10:18.854968Z 0 [Warning] Can't create test file D:\soft\mysql\mysql-5.7.10\data\yzl021.lower-test
2015-12-09T03:10:18.856879Z 0 [ERROR] failed to set datadir to D:\soft\mysql\mysql-5.7.10\data\
2015-12-09T03:10:18.861884Z 0 [ERROR] Aborting

2015-12-09T03:10:18.862897Z 0 [Note] Binlog end
2015-12-09T03:10:18.863567Z 0 [Note] mysqld: Shutdown complete

PHP中文网
PHP中文网

认证高级PHP讲师

全部回覆(2)
左手右手慢动作

Can't change dir to 'D:softmysqlmysql-5.7.10data' (Errcode: 2 - No such file or directory)
哥們你資料庫檔案儲存的路徑不存在
重新運行一下MySQLInstanceConfig,重新配置資料庫檔案的儲存路徑。

Peter_Zhu

問題解決了 執行指令 mysqld --initialize --user=mysql --console

缺少data
http://www.oschina.net/question/1244397_2138435

熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板
關於我們 免責聲明 Sitemap
PHP中文網:公益線上PHP培訓,幫助PHP學習者快速成長!