我一般使用mysql绿色版。在dos环境下进入bin目录,使用命令mysqld -nt --skip-grant-tables 启动mysql,关闭权限的检查
忽然有一天,这个命令不能使用了
错误如下F:\game\mysql\bin>mysqld -nt --skip-grant-tables
2015-01-03 09:59:41 0 [Warning] option 'new': boolean value 't' wasn't recognize
d. Set to OFF.
2015-01-03 09:59:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2015-01-03 09:59:41 3728 [ERROR] Can't find messagefile 'C:\Program Files\myeye\
mysql5\share\errmsg.sys'
2015-01-03 09:59:41 3728 [Warning] Can't create test file C:\Program Files\myeye
\mysql5\Data\www-a2cff407694.lower-test
2015-01-03 09:59:41 3728 [Warning] Can't create test file C:\Program Files\myeye
\mysql5\Data\www-a2cff407694.lower-test
mysqld: Can't change dir to 'C:\Program Files\myeye\mysql5\Data\' (Errcode: 2 -
No such file or directory)
2015-01-03 09:59:41 3728 [ERROR] Aborting2015-01-03 09:59:41 3728 [Note] Binlog end
2015-01-03 09:59:41 3728 [Note]我做了两个操作。一个是检查是否端口被占用。netstat -ano|findstr "3306" 显示没有
第二就是换了配置文件。但是还是没有反应。求大神指导。什么原因。还有上面提示c盘的目录不知道做什么的。好像没有关系
我在其它电脑上都没有问题。求指导
忽然有一天,这个命令不能使用了
错误如下F:\game\mysql\bin>mysqld -nt --skip-grant-tables
2015-01-03 09:59:41 0 [Warning] option 'new': boolean value 't' wasn't recognize
d. Set to OFF.
2015-01-03 09:59:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2015-01-03 09:59:41 3728 [ERROR] Can't find messagefile 'C:\Program Files\myeye\
mysql5\share\errmsg.sys'
2015-01-03 09:59:41 3728 [Warning] Can't create test file C:\Program Files\myeye
\mysql5\Data\www-a2cff407694.lower-test
2015-01-03 09:59:41 3728 [Warning] Can't create test file C:\Program Files\myeye
\mysql5\Data\www-a2cff407694.lower-test
mysqld: Can't change dir to 'C:\Program Files\myeye\mysql5\Data\' (Errcode: 2 -
No such file or directory)
2015-01-03 09:59:41 3728 [ERROR] Aborting2015-01-03 09:59:41 3728 [Note] Binlog end
2015-01-03 09:59:41 3728 [Note]我做了两个操作。一个是检查是否端口被占用。netstat -ano|findstr "3306" 显示没有
第二就是换了配置文件。但是还是没有反应。求大神指导。什么原因。还有上面提示c盘的目录不知道做什么的。好像没有关系
我在其它电脑上都没有问题。求指导
No such file or directory)
数据目录删掉了?执行下mysql_install_db试试
No such file or directory)目录不存在