my.cnf 598 B

123456789101112131415161718192021222324
  1. [client]
  2. port = 3306
  3. socket = /var/run/mysqld/mysqld.sock
  4. [mysqld_safe]
  5. pid-file = /var/run/mysqld/mysqld.pid
  6. nice = 0
  7. [mysqld]
  8. user = mysql
  9. basedir = /usr
  10. datadir = /var/lib/mysql
  11. tmpdir = /tmp
  12. lc-messages-dir = /usr/share/mysql
  13. explicit_defaults_for_timestamp
  14. skip-grant-tables
  15. lower_case_table_names = 1
  16. character-set-server = utf8mb4
  17. collation-server = utf8mb4_unicode_ci
  18. sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  19. #bind-address = 127.0.0.1
  20. log-error = /var/log/mysql/error.log
  21. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  22. symbolic-links=0
  23. !includedir /etc/mysql/conf.d/