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 |