mysqld 5.6 service error 1067

Posted on

mysqld 5.6 service error 1067 – Managing your servers can streamline the performance of your team by allowing them to complete complex tasks faster. Plus, it can enable them to detect problems early on before they get out of hand and compromise your business. As a result, the risk of experiencing operational setbacks is drastically lower.

But the only way to make the most of your server management is to perform it correctly. And to help you do so, this article will share nine tips on improving your server management and fix some problem about windows, mysql, database, windows-service, .

Upon running this service

"C:Program FilesMySQLMySQL Server 5.6binmysqld" --defaults-file="C:ProgramDataMySQLMySQL Server 5.6my.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…

Solution :

$ 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.

Leave a Reply

Your email address will not be published. Required fields are marked *