mysql 初始化工具完美兼容mysql 8.0版本.

分类
Qampp手册
更新时间
2018-04-20 14:40:21

指定你的mysql目录..



默认账号密码为root, root.

看到数据库列表显示, 表示已经成功.


下载地址:

http://www.atuser.com/down/link/secode/mysqlinit


支持最新版本mysql 8.0.11


分享一个ini配置文件, 支持8, 5版本.

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
port=3306 
basedir="D:/Qampp/mysql/"
datadir="D:/Qampp/mysql/data/"
tmpdir="D:/Qampp/mysql/data/"
socket = "D:/Qampp/mysql/data/mysql.sock"
log-error="D:/Qampp/mysql/data/mysql_error.log"
character-set-server=utf8mb4

#server_id = 2
#skip-locking
skip-ssl

early-plugin-load=""
max_connections=100
table_open_cache=256 

tmp_table_size=8M
thread_cache_size=8

innodb_data_file_path = ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit =1

innodb_log_buffer_size=8M
innodb_buffer_pool_size=8M
innodb_log_file_size=8M
innodb_thread_concurrency=16

join_buffer_size = 8M
sort_buffer_size = 8M
read_rnd_buffer_size = 8M 

max_allowed_packet = 32M
explicit_defaults_for_timestamp=true

#sql-mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4


END


分享工作室[粤ICP备16004795号-2] 腾讯云 / 腾讯AI / 南沙新区 / 信用 0.016