So my local mysql server is complaining about invalid timestamp valid of
And I happen to have 2 of these columns and whenever I tried to fix one of them, MYSQL complains the other is having the
invalid default value and doesn't allow me to change anything!
I even asked the question here: http://dba.stackexchange.com/questions/153237/cannot-alter-mysql-table-stuck-in-a-invalid-default-value-loop.
So the problem turns out is because of the
And to solve that, if you're installed mysql with homebrew like me, you'll find that you couldn't find the
my.cnf file anywhere!
So with reference to: http://stackoverflow.com/questions/7973927/for-homebrew-mysql-installs-wheres-my-cnf, where's what you need to do.
- Restart the server
To find the
my-default.cnf, it'll be in the mysql installation folder. Mine is in
Actually that's all I did because if you look into
NO_ZERO_DATE is not part of the
Here's mine for reference: