I start database error: [Warning] Using the unique option prefix home key_buffer key_buffer_size is deprecated and will be removed in a future release. Do use the full name home.
The 2019-10-28 13:48:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Do use - explicit_defaults_for_timestamp server option (see documentation for more details).


Navicat are not


How to solve this?

CodePudding user response:

Urgent urgent, online, etc., for a great god solve!!!!!!!!!!!!!!!!!!!!!

CodePudding user response:

In mysql/my. In the ini file (mysqld) add a line under explicit_defaults_for_timestamp=true, it is ok to
The meaning of this statement is # open query cache, which is one of the web cache, only requires to repeat the query cache read can reduce the access to the database,

You give it a try

CodePudding user response:

The service did not start you? What version of the database? According to the system?

CodePudding user response:

You start just warning, not the error
Did you first take a look at the mysql start (to find corresponding service)