SHARE
TWEET

Untitled

a guest Dec 13th, 2016 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Example MySQL config file for small systems.
  2. #
  3. # This is for a system with little memory (<= 64M) where MySQL is only used
  4. # from time to time and it's important that the mysqld daemon
  5. # doesn't use much resources.
  6. #
  7. # You can copy this file to
  8. # C:/xampp/mysql/bin/my.cnf to set global options,
  9. # mysql-data-dir/my.cnf to set server-specific options (in this
  10. # installation this directory is C:/xampp/mysql/data) or
  11. # ~/.my.cnf to set user-specific options.
  12. #
  13. # In this file, you can use all long options that a program supports.
  14. # If you want to know which options a program supports, run the program
  15. # with the "--help" option.
  16.  
  17. # The following options will be passed to all MySQL clients
  18. [client]
  19. # password       =
  20. port            = 3306
  21. socket          = "C:/xampp/mysql/mysql.sock"
  22.  
  23.  
  24. # Here follows entries for some specific programs
  25.  
  26. # The MySQL server
  27. [mysqld]
  28. port= 3306
  29. socket = "C:/xampp/mysql/mysql.sock"
  30. basedir = "C:/xampp/mysql"
  31. tmpdir = "C:/xampp/tmp"
  32. datadir = "C:/xampp/mysql/data"
  33. pid_file = "mysql.pid"
  34. # enable-named-pipe
  35. key_buffer = 16M
  36. max_allowed_packet = 1M
  37. sort_buffer_size = 512K
  38. net_buffer_length = 8K
  39. read_buffer_size = 256K
  40. read_rnd_buffer_size = 512K
  41. myisam_sort_buffer_size = 8M
  42. log_error = "mysql_error.log"
  43.  
  44. # Change here for bind listening
  45. # bind-address="127.0.0.1"
  46. # bind-address = ::1          # for ipv6
  47.  
  48. # Where do all the plugins live
  49. plugin_dir = "C:/xampp/mysql/lib/plugin/"
  50.  
  51. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  52. # if all processes that need to connect to mysqld run on the same host.
  53. # All interaction with mysqld must be made via Unix sockets or named pipes.
  54. # Note that using this option without enabling named pipes on Windows
  55. # (via the "enable-named-pipe" option) will render mysqld useless!
  56. #
  57. # commented in by lampp security
  58. #skip-networking
  59. #skip-federated
  60.  
  61. # Replication Master Server (default)
  62. # binary logging is required for replication
  63. # log-bin deactivated by default since XAMPP 1.4.11
  64. #log-bin=mysql-bin
  65.  
  66. # required unique id between 1 and 2^32 - 1
  67. # defaults to 1 if master-host is not set
  68. # but will not function as a master if omitted
  69. server-id   = 1
  70.  
  71. # Replication Slave (comment out master section to use this)
  72. #
  73. # To configure this host as a replication slave, you can choose between
  74. # two methods :
  75. #
  76. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
  77. #    the syntax is:
  78. #
  79. #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
  80. #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
  81. #
  82. #    where you replace <host>, <user>, <password> by quoted strings and
  83. #    <port> by the master's port number (3306 by default).
  84. #
  85. #    Example:
  86. #
  87. #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
  88. #    MASTER_USER='joe', MASTER_PASSWORD='secret';
  89. #
  90. # OR
  91. #
  92. # 2) Set the variables below. However, in case you choose this method, then
  93. #    start replication for the first time (even unsuccessfully, for example
  94. #    if you mistyped the password in master-password and the slave fails to
  95. #    connect), the slave will create a master.info file, and any later
  96. #    change in this file to the variables' values below will be ignored and
  97. #    overridden by the content of the master.info file, unless you shutdown
  98. #    the slave server, delete master.info and restart the slaver server.
  99. #    For that reason, you may want to leave the lines below untouched
  100. #    (commented) and instead use CHANGE MASTER TO (see above)
  101. #
  102. # required unique id between 2 and 2^32 - 1
  103. # (and different from the master)
  104. # defaults to 2 if master-host is set
  105. # but will not function as a slave if omitted
  106. #server-id       = 2
  107. #
  108. # The replication master for this slave - required
  109. #master-host     =   <hostname>
  110. #
  111. # The username the slave will use for authentication when connecting
  112. # to the master - required
  113. #master-user     =   <username>
  114. #
  115. # The password the slave will authenticate with when connecting to
  116. # the master - required
  117. #master-password =   <password>
  118. #
  119. # The port the master is listening on.
  120. # optional - defaults to 3306
  121. #master-port     =  <port>
  122. #
  123. # binary logging - not required for slaves, but recommended
  124. #log-bin=mysql-bin
  125.  
  126.  
  127. # Point the following paths to different dedicated disks
  128. #tmpdir = "C:/xampp/tmp"
  129. #log-update = /path-to-dedicated-directory/hostname
  130.  
  131. # Uncomment the following if you are using BDB tables
  132. #bdb_cache_size = 4M
  133. #bdb_max_lock = 10000
  134.  
  135. # Comment the following if you are using InnoDB tables
  136. #skip-innodb
  137. innodb_data_home_dir = "C:/xampp/mysql/data"
  138. innodb_data_file_path = ibdata1:10M:autoextend
  139. innodb_log_group_home_dir = "C:/xampp/mysql/data"
  140. #innodb_log_arch_dir = "C:/xampp/mysql/data"
  141. ## You can set .._buffer_pool_size up to 50 - 80 %
  142. ## of RAM but beware of setting memory usage too high
  143. innodb_buffer_pool_size = 16M
  144. innodb_additional_mem_pool_size = 2M
  145. ## Set .._log_file_size to 25 % of buffer pool size
  146. innodb_log_file_size = 5M
  147. innodb_log_buffer_size = 8M
  148. innodb_flush_log_at_trx_commit = 1
  149. innodb_lock_wait_timeout = 50
  150.  
  151. ## UTF 8 Settings
  152. #init-connect=\'SET NAMES utf8\'
  153. #collation_server=utf8_unicode_ci
  154. #character_set_server=utf8
  155. #skip-character-set-client-handshake
  156. #character_sets-dir="C:/xampp/mysql/share/charsets"
  157.  
  158. [mysqldump]
  159. quick
  160. max_allowed_packet = 16M
  161.  
  162. [mysql]
  163. no-auto-rehash
  164. # Remove the next comment character if you are not familiar with SQL
  165. #safe-updates
  166.  
  167. [isamchk]
  168. key_buffer = 20M
  169. sort_buffer_size = 20M
  170. read_buffer = 2M
  171. write_buffer = 2M
  172.  
  173. [myisamchk]
  174. key_buffer = 20M
  175. sort_buffer_size = 20M
  176. read_buffer = 2M
  177. write_buffer = 2M
  178.  
  179. [mysqlhotcopy]
  180. interactive-timeout
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top