Windows and Mysql: slow connection to database
If you have windows 7 or newer and connects to the mysql database, you may be happened that the connection is very slow.
Problem comes only when you are connecting via localhost. If you use a similar configuration of this
Objective-C
1 2 3 4 5 6 |
database.driver = mysql database.host = localhost database.username = lsd database.password = lsd00454 database.database = viamail database.profiler = true |
Server is attempting to open a connection to localhost, but if your computer is connected via IPv6, the computer searches the first IP address that is :: 1.
After failure create server loop and redirect connection to IPv4 and search localhost here.
Will help change the configuration
Objective-C
1 2 3 4 5 6 |
database.driver = mysql database.host = 127.0.0.1 database.username = lsd database.password = lsd00454 database.database = viamail database.profiler = true |
Posted on 13 April 2013