Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Upon running this service

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56

I get this error

windows could not start mysql56 service of local computer
error 1067 the process terminated unexpectedly

http://i.imgur.com/317MOrF.png


However running just mysqld.exe runs OK http://i.imgur.com/FVaAZYG.png But it won't accept my saved passwords and databases..



Similar question mysql server does not start! suggests that it's a directory issue, I've checked all the directories and they are exactly what they should be like (i guess..) http:\i.imgur,com/t76KGR0.png (link: need 10+ reps)


Also, it was working just 10 days ago. I haven't messed with anything I can remember...

share|improve this question

1 Answer 1

$ perror 1067
MySQL error code 1067 (ER_INVALID_DEFAULT): Invalid default value for '%-.192s'

Check your mysql log file and find out which parameter in your config is causing problems.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.