Advanced Search

A example option file for mysql in windows

/ Published in: MySQL
Save to your folder(s)
`mysql-dev.ini` can be used in a developing environment and put it in the Mysql Home dir

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.