新建本地mysql连接
1.删空data文件夹。（如果是再次安装的话）
2.在bin目录下加my.ini文件
[client]
port=3306
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir=“D:\SoftWare\MYSQL\mysql\mysql-5.7.19-winx64”
datadir=“D:\SoftWare\MYSQL\mysql\mysql-5.7.19-winx64\data”
character-set-server=utf8
[WinMySQLadmin]
Server=“D:\SoftWare\MYSQL\mysql\mysql-5.7.19-winx64\bin\mysqld.exe”
default-character-set=utf8
default-storage-engine=INNODB
sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=26M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=52M
key_buffer_size=40M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
Use this option if you have a MySQL server withInnoDB support enabled
but you do not plan to use it. This will save memoryand disk space
and speed up some things.
#skip-innodb
Additional memory pool that is used by InnoDB tostore metadata
information. If InnoDB requires more memory for this purpose it will
start to allocate it from the OS. As this is fast enough on most
recent operating systems, you normally do not needto change this
value. SHOW INNODB STATUS will display the currentamount used.
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=77M
innodb_log_file_size=39M
innodb_thread_concurrency=8
3.打开cmd(管理员权限)，进到%path%bin目录下，输入命令 msyqld --initialize --console
4.然后输入 mysqld install .然后启动服务器 net start mysql
5.添加一个root用户。然后更密码。
mysql -u root -p
set password for root@localhost = password(‘123456’);
mysql服务可以启动啦！
6.先新建一个数据库
mysql> SHOW DATABASES;
mysql> CREATE DATABASE 库名;
7.在dbeaver新建连接
库名为刚刚建的库名
8.设置驱动属性
（JDBC：The server time zone value ‘�й���ʱ��‘ is unrecognized or represents more than one time zone.）
DBEAVER/IDEA设置
无论是什么工具或者IDE，中心思想都是增加一个serverTimezone的驱动属性，value= Asia/Shanghai
9.测试连接，成功！