1,478
edits
Line 3: | Line 3: | ||
This page contains known issues and problems, where applicable offers solutions. | This page contains known issues and problems, where applicable offers solutions. | ||
== MySQL host name 127.0.0.1 or localhost == | |||
The following applies to Windows 7 users. | |||
=== No registry dust and portable === | |||
MySQL 5 supports only IPv4 unfortunately Windows 7 gives priority to IPv6 and returns an IPv6 address for '''localhost''' hence a connection fails. | |||
Uniform Server’s solution is to replace '''localhost''' with port address '''127.0.0.1''' this forces an IPv4 connection. | |||
* When requested for a MySQL '''host name''' use '''127.0.0.1''' | |||
=== Registry dust and portability sacrificed === | |||
I like alternatives and if you wish to use localhost as the MySQL host name perform the following: | |||
* Run regedit and create a DWORD entry at | |||
** HKLM\SYSTEM\CurrentControlSet\services\TCPIP6\Parameters called “DisabledComponents”, | |||
* Set value to 0x20. it sets IPv4 to be preferred over IPv6 | |||
Full details of this solution is found on [http://bobstrand.com '''Bob Strand’s'''] website. | |||
See page: [http://bobstrand.com/totm/2010/04/13/hey-dude-wheres-my-localhost/ '''hey-dude-wheres-my-localhost'''] | |||
== Services not starting == | == Services not starting == |