Java project saved after MySQL change question mark the solution of MySQL 5.6 (X64) Decompression version 1067 error and coding problem

Environment Java Environment JDK1.8 installed mysql-5.6.38-winx64 idea2016 (64)

The problem is this: Idea debugging Eclips project into the database and changing question marks

First of all, Eclips and release of the project is not a problem, the first thought is the coding problem, so check the project and database code, but see that the code is UTF-8, the database is viewed through (navicat)

But there are articles on the Internet that say that the JDBC connection string is added to the Useunicode=true&characterencoding=utf8 (the test does not work). Some articles brought up SHOW VARIABLES like ' character_set_% '; (in the cmd in the MySQL client execution) This sentence is very important, found that my list is basically all gbk,alter database ' xxx ' charset utf8 useless, and then remembered the My.ini set CharSet, so the nightmare began. found that my database directory does not have my.ini only one my-default.ini and the basic is all annotated, leaving only one sentence. So look online said, some in windows, some said in C program file some said D program file some said Win7 (X64) under Programdata or hidden I was win764, above settings show hidden display system files, no fruit. MySQL is the reference degree Niang

How to install Mysql,mysql two kinds of installation method _ Baidu experience installed, there is no mention of My.ini in the way to read the other article said before the installation to copy Mydefault.ini into My.ini so copy, configuration, sad reminder is the discovery service tip 1067 can not start unloading load, View Windows log,,, (unable to find the installation directory Error.sys?) go to the other directory and find it again My.ini finally calmly think I have my.ini to report. So a sentence of the test, found that the configuration of

Basedir=e:\mysql\mysql-5.6.23-winx64datadir=e:\mysql\mysql-5.6.23-winx64\data
Will be reported 1067  and then remove the above two configuration, normal start!!!!!!!!!!!!!!!!!!!!

(Many articles say that these two are basic configurations, and even other configurations can be removed from both, this pit is too deep)
The following is the current configuration

#########################################################
[Client]
port=3306
Default-character-set=utf8
[Mysqld]
port=3306
Character_set_server=utf8

Sql_mode=no_engine_substitution,strict_trans_tables
[Winmysqladmin]
D:\**********************\mysql-5.6.38-winx64\bin\mysqld.exe

Execute SHOW VARIABLES like ' character_set_% '; The list has changed to UTF8 there is a binary debug ok ....... .......

Java project saved after MySQL change question mark the solution of MySQL 5.6 (X64) Decompression version 1067 error and coding problem