Root Password Reset, -explicit_defaults_for_timestamp Issue

[Colin Millard]

Hi All

I know I should not be having these issues, but at the moment I don't understand the
problem !


I created a txt file with the following code:

UPDATE mysql.user SET Password=PASSWORD('MyNewPassword') WHERE User='root';
FLUSH PRIVILEGES;

mysqld.exe --init-file=C:\mysql-init.txt

I get the following error 'Please use --explicit_defaults_for_timestamp'

Do I need to add something to the mysql-init.txt ???

Help !!

Thanks

Colin