Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

However running just mysqld.exe runs OK 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
$ 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


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.