Tag Archives: TIMESTAMP with implicit DEFAULT value is deprecated

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated.

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated.

 

During the installation of the free version of mysql it appears that:\java_software\mysql-5.6.21-winx64\mysql-5.6.21-winx64\bin>mysqld mysql
2017-04-01 10:44:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
Solution: You need to add

explicit_defaults_for_timestamp=true

 

Run mysqld install as an administrator to prompt that the installation is successful
start MySQL: Net start Mysql to start the MySQL service. For the convenience of future development, you can set automatic start. Win + R run services.msc settings
configure environment variables: MySQL_ Home/bin
Run MySQL: MySQL – U root – P password, which is empty by default

My.ini may not exist in the installation directory of MySQL, so it needs to be created by myself_ The default.ini is directly changed to my.ini