[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

Similar Posts:

• MySQL 5.7 installation, mysql. Plugin ‘doesn’t exist error resolution
• Mysql5.7 service startup error on Windows
• [Solved] MYSQL database adds timestamp field error: Invalid default value for’xxx’
• Solution to the error of MySQL: unrecognized service (CentOS)
• When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
• The ‘MySQL daemon failed to start’ solution appears
• How to Solve MYSQL Startup Error: “MySQL Daemon failed to start”
• MySQL installation error — failed to find valid data directory
• [Solved] MYSQL8 Error: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
• When installing MySQL database on MAC, the system prompts MySQL: command not found