my.cnf 446 B

12345678910111213141516171819
  1. [mysqld]
  2. default-storage-engine=INNODB
  3. character-set-server=utf8mb4
  4. lower_case_table_names=1
  5. max_connections=1000
  6. sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
  7. #secure_file_priv=/var/lib/mysql
  8. #enable binlog
  9. server_id=1
  10. log_bin=/var/lib/mysql/mysql-bin
  11. binlog_format=ROW
  12. binlog_expire_logs_seconds=604800
  13. [client]
  14. default-character-set=utf8mb4
  15. [mysql]
  16. default-character-set=utf8mb4