Posted By

jacktan on 10/30/14


Tagged

mysql windows option-file


Versions (?)

A example option file for mysql in windows


 / Published in: MySQL
 

mysql-dev.ini can be used in a developing environment and put it in the Mysql Home dir

  1. [client]
  2. host=localhost
  3. port=3306
  4. user=root
  5. password=
  6.  
  7. default-character-SET=utf8
  8. connect_timeout=2
  9.  
  10. [mysql]
  11. max_allowed_packet=16M
  12. tee=mysql_result.LOG
  13.  
  14. [mysqld]
  15. basedir=.\\
  16. datadir=.\\data
  17.  
  18. explicit_defaults_for_timestamp=TRUE
  19.  
  20. port=3306
  21. server_id=3141526
  22.  
  23. sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  24.  
  25. key_buffer_size=8M
  26. max_allowed_packet=8M
  27. max_connections=100
  28. query_cache_size=0
  29. table-open-cache=64
  30. tmp_table_size=32M
  31. thread_cache_size=8
  32.  
  33. log-error=error.LOG
  34.  
  35. character-set-server=utf8
  36. collation-server=utf8_general_ci
  37.  
  38.  
  39. default-storage-engine=INNODB
  40. innodb_flush_log_at_trx_commit=2
  41. innodb_log_buffer_size=1M
  42. innodb_buffer_pool_size=8M
  43. innodb_log_file_size=22M
  44. innodb_thread_concurrency=8

Report this snippet  

You need to login to post a comment.