SHOW:
|
|
- or go back to the newest paste.
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:/Users/root/Desktop/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:/Users/root/Desktop/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 = LECfG6WV4Hf2ChPn | |
20 | port = 3306 | |
21 | socket = "C:/Users/root/Desktop/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:/Users/root/Desktop/xampp/mysql/mysql.sock" | |
30 | basedir = "C:/Users/root/Desktop/xampp/mysql" | |
31 | tmpdir = "C:/Users/root/Desktop/xampp/tmp" | |
32 | datadir = "C:/Users/root/Desktop/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" |
45 | + | bind-address="0.0.0.0" |
46 | # bind-address = ::1 # for ipv6 | |
47 | ||
48 | # Where do all the plugins live | |
49 | plugin_dir = "C:/Users/root/Desktop/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:/Users/root/Desktop/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:/Users/root/Desktop/xampp/mysql/data" | |
138 | innodb_data_file_path = ibdata1:10M:autoextend | |
139 | innodb_log_group_home_dir = "C:/Users/root/Desktop/xampp/mysql/data" | |
140 | #innodb_log_arch_dir = "C:/Users/root/Desktop/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:/Users/root/Desktop/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 |