Re: 5.7.9 MySQL install failure to start server

[Keith Menelaws]

"Best test the service cmd manually:

from services.msc copy from Properties the MySQL server cmd the service is using (Properties), in a cmd.exe window execute that command with the additional arguments ..."


Ok firstly, are you referring to the Properties general tab “Path to executable”?

If so, is this the command to be entered?

C:\Program Files\MySQL\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\my.ini" MySQL57 --console –-skip-grant-tables


I used the usual cmd mysql startup with your added arguments and got:

c:\Program Files\MySQL\bin>mysqld --console --skip-grant-tables
2015-11-24T12:31:53.729504Z 0 [Warning] option 'read_buffer_size': unsigned valu
e 5120 adjusted to 8192
2015-11-24T12:31:53.729504Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is
deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
2015-11-24T12:31:53.729504Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E
RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will
be merged with strict mode in a future release.
2015-11-24T12:31:53.729504Z 0 [Note] mysqld (mysqld 5.7.9-log) starting as proce
ss 3228 ...
mysqld: File 'C:\Program Files\MySQL\MySQL Server 5.7\logs\bin.index' not found
(Errcode: 2 - No such file or directory)
2015-11-24T12:31:53.776373Z 0 [ERROR] Aborting

2015-11-24T12:31:53.776373Z 0 [Note] Binlog end
2015-11-24T12:31:53.776373Z 0 [Note] mysqld: Shutdown complete

Should I be concerned with these warnings?