mysql5.6.16直接官网下的zip包,命令行启动mysqld:
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option
添加 代码:
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 128M
port = 3306
socket = MySQL
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
server-id= 1
character-set-server=gbk
default-storage-engine=INNODB
#开启查询缓存
explicit_defaults_for_timestamp=true
添加后就不再显示错误了。