Solution:
Add the following configuration under the mysql configuration file /etc/my.cnf. Add under the
[mysqld] node.
explicit_defaults_for_timestamp = ON
Restart the mysql database and try the configuration to take effect.
Restart command service mysqld restart
Similar Posts:
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
- When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
- How to Solve MYSQL Startup Error: “MySQL Daemon failed to start”
- How to Solve MYSQL error “no directory, logging in with home = -“
- The ‘MySQL daemon failed to start’ solution appears
- MySQL Error: the solution of command not found
- MySQL service failed to read description, error code: 2
- Solution to the error of MySQL: unrecognized service (CentOS)
- The solution of 2003 can’t connect to MySQL server on ‘localhost’ (10061)
- Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist