C:\Users\Administrator>net start mysql
MySQL 服务正在启动 ...
MySQL 服务无法启动。
系统出错。
发生系统错误 1067。
进程意外终止。
---------------------------------
试了网上各种方法,都没能解决。
最后,在一个帖子里看到让用mysqld --default-file=安装目录\my-default.ini的方式启动试试。
---------------------------------
D:\SoftWare\mysql-5.6.35-x64\bin>mysqld --default-file=D:\SoftWare\mysql-5.6.35-x64\my-default.ini
2018-05-04 09:30:21 0 [Warning] option 'net_buffer_length': unsigned value 16777216 adjusted to 1048576
2018-05-04 09:30:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --
explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-04 09:30:21 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-05-04 09:30:21 0 [Note] mysqld (mysqld 5.6.35-log) starting as process 2308 ...
2018-05-04 09:30:21 2308 [Warning] Can't create test file \app\mysql\data\PC20160826KLQJ.lower-test
2018-05-04 09:30:21 2308 [Warning] Can't create test file \app\mysql\data\PC20160826KLQJ.lower-test
mysqld: Can't change dir to '\app\mysql\data\' (Errcode: 2 - No such file or directory)
2018-05-04 09:30:21 2308 [ERROR] Aborting
---------------------------------
突然发现报错里的路径\app\mysql\data\竟然是我linux虚拟机里面mysql!!!然后就开始在电脑里搜索mysql在linux下的配置文件my.cnf,果然在C:\下找到了。
删掉它。再在CMD下执行
C:\Users\Administrator>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
MySQL 服务正在启动 ...
MySQL 服务无法启动。
系统出错。
发生系统错误 1067。
进程意外终止。
---------------------------------
试了网上各种方法,都没能解决。
最后,在一个帖子里看到让用mysqld --default-file=安装目录\my-default.ini的方式启动试试。
---------------------------------
D:\SoftWare\mysql-5.6.35-x64\bin>mysqld --default-file=D:\SoftWare\mysql-5.6.35-x64\my-default.ini
2018-05-04 09:30:21 0 [Warning] option 'net_buffer_length': unsigned value 16777216 adjusted to 1048576
2018-05-04 09:30:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --
explicit_defaults_for_timestamp server option (see documentation for more details).
2018-05-04 09:30:21 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-05-04 09:30:21 0 [Note] mysqld (mysqld 5.6.35-log) starting as process 2308 ...
2018-05-04 09:30:21 2308 [Warning] Can't create test file \app\mysql\data\PC20160826KLQJ.lower-test
2018-05-04 09:30:21 2308 [Warning] Can't create test file \app\mysql\data\PC20160826KLQJ.lower-test
mysqld: Can't change dir to '\app\mysql\data\' (Errcode: 2 - No such file or directory)
2018-05-04 09:30:21 2308 [ERROR] Aborting
---------------------------------
突然发现报错里的路径\app\mysql\data\竟然是我linux虚拟机里面mysql!!!然后就开始在电脑里搜索mysql在linux下的配置文件my.cnf,果然在C:\下找到了。
删掉它。再在CMD下执行
C:\Users\Administrator>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。