win10安装mysql时提示错误:mysqld: Can't change dir to 'C: oftware\mysql\data\' (Errcode: 2 - No such file or directory)
win10安装解压版mysql时,提示错误:
2019-10-22 09:02:00 2004 [ERROR] Can't find messagefile 'C:\WINDOWS\system32\ oftware\mysql\share\errmsg.sys'
2019-10-22 09:02:00 2004 [Warning] Can't create test file C: oftware\mysql\data\LAPTOP-8BENTBQO.lower-test
2019-10-22 09:02:00 2004 [Warning] Can't create test file C: oftware\mysql\data\LAPTOP-8BENTBQO.lower-test
mysqld: Can't change dir to 'C: oftware\mysql\data\' (Errcode: 2 - No such file or directory)
2019-10-22 09:02:00 2004 [ERROR] Aborting
原因分析:
- 在解压目录下存在data目录,说明路径是存在的;
- 可能是my.ini配置文件设置问题,将basedir和datadir设置的路径中的单反斜线改为双反斜线,bingo!问题解决。
my.ini中的配置:
basedir = C:\\software\mysql
datadir = C:\\software\\mysql\\data
port = 3306
God will send the rain when you are ready.You need to prepare your field to receive it.