Manual:Running MediaWiki on Windows/MySQL my.ini

Below is a copy of a sample  file configured in the right way to be used with MediaWiki. Often this file is placed in your windows root directory. Also see full article.

[mysqld] ;  enable-named-pipe port	= 3306 socket = /tmp/mysql.sock ; password = mypassword skip-locking key_buffer_size=32M table_cache = 256 sort_buffer_size = 4M myisam_sort_buffer_size = 8M max_allowed_packet = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M join_buffer_size = 4M thread_stack = 256K ; myisam-recover = BACKUP,FORCE set-variable = flush-time=3600 basedir = C:/Program Files/MySQL datadir = C:/MySQL data tmpdir = C://MySQL temp log-warnings ; skip-networking bind-address=127.0.0.1 ;  thread_cache = 8 ;  query_cache_size= 16M # Replication Master Server (default) # binary logging is required for replication log-bin= # required unique id between 1 and 2^32 - 1 # will not function as a master if omitted server-id = 1 # Table name casing, see: http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html # 0 = store using stated case (default on unix, can corrupt MyISAM on windows) # 1 = store in lower case, ignore casing (works on both windows and unix) # 2 = store using stated case, do not check casing on reference (only works on Windows) # If you are using MySQL on only one platform, you don't normally have to change the # lower_case_table_names variable. However, you may encounter difficulties if you want to transfer # tables between platforms that differ in filesystem case sensitivity. For example, on Unix, you can # have two different tables named my_table and MY_TABLE, but on Windows those names are # considered the same. To avoid data transfer problems stemming from database or table name # lettercase, you have two options: # Use lower_case_table_names=1 on all systems. The main disadvantage with this is that when you # use SHOW TABLES or SHOW DATABASES, you don't see the names in their original lettercase. # Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This # preserves the lettercase of database and table names. The disadvantage of this is that you must # ensure that your queries always refer to your database and table names with the correct lettercase # on Windows. If you transfer your queries to Unix, where lettercase is significant, they will not work # if the lettercase is incorrect. # Note that before setting lower_case_table_names to 1 on Unix, you must first convert your old # database and table names to lowercase before restarting mysqld. # WINDOWS OPTION !!! CHANGE IF USED ON UNIX! lower_case_table_names=2 [mysql] no-auto-rehash [client] ; password = mypassword port		= 3306 socket	= /tmp/mysql.sock [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/Program Files/MySQL/bin/mysqld-max-nt.exe QueryInterval=10