my.cnf 893 B

1234567891011121314151617181920
  1. [mysqld]
  2. user=mysql # MySQL启动用户
  3. default-storage-engine=INNODB # 创建新表时将使用的默认存储引擎
  4. character-set-server=utf8mb4 # 设置mysql服务端默认字符集
  5. pid-file = /var/run/mysqld/mysqld.pid # pid文件所在目录
  6. socket = /var/run/mysqld/mysqld.sock # 用于本地连接的socket套接字
  7. datadir = /var/lib/mysql # 数据文件存放的目录
  8. #log-error = /var/log/mysql/error.log
  9. #bind-address = 127.0.0.1 # MySQL绑定IP
  10. symbolic-links=0
  11. sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION # 定义mysql应该支持的sql语法,数据校验等!
  12. # 允许最大连接数
  13. max_connections=1000
  14. [mysql]
  15. default-character-set=utf8mb4
  16. [client]
  17. default-character-set=utf8mb4 # 设置mysql客户端默认字符集