[client]
port = 3700 #端口
socket = /tmp/mysql.sock #如果主機上運行了多個mysql，請注意區分開來
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
server_id = 13000
port = 3700
user = mysql
character-set-server = utf8mb4
default_storage_engine = innodb
log_timestamps = SYSTEM
socket = /tmp/mysql.sock #如果主機上運行了多個mysql，請注意區分開來
basedir = /export/local/mysql #數據庫安裝目錄
datadir = /data/mysql/data #數據庫數據目錄
pid-file = /data/mysql/data/mysql.pid #PID文件路徑
max_connections = 10000
max_connect_errors = 10000
table_open_cache = 1024
max_allowed_packet = 128M
open_files_limit = 65535
lower_case_table_names = 1
innodb_buffer_pool_size = 1024M
innodb_file_per_table = 1
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_purge_threads = 2
innodb_flush_log_at_trx_commit = 1
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
innodb_log_buffer_size = 16M
innodb_max_dirty_pages_pct = 80
innodb_lock_wait_timeout = 30
innodb_data_file_path = ibdata1:10M:autoextend
slow_query_log = 1
long_query_time = 1
log_error = /data/mysql/log/mysql-3700-error.log #日志路徑
slow_query_log_file = /data/mysql/log/mysql-3700-slow.log
transaction-isolation=Read-Committed

log-bin = mysql-bin
innodb_flush_log_at_trx_commit = 1
binlog_ignore_db = mysql

lower_case_table_names=1      #不區分大小寫，其實都是轉換成小寫
max_connect_errors=1000

GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'your password';

flush privileges;