Mysql_connect takes a long time to complete

Question

I have a script in php to login to mysql

$db_host="localhost"; $db_user="root"; $db_pass="123"; $dbc=mysql_connect($db_host,$db_user,$db_pass) OR DIE (mysql_error()); $dbs=mysql_select_db($db_name) OR DIE (mysql_error()); 

this script worked fine, now I am reinstalling the OS now I have windows 7 and iis7 and PHP version 5.3.2 and mysql server 5.1 but now this script does not work and takes registration time.

thanks

Answer 1

On Windows 7, localhost resolves to ::1 , and MySQL does not support IPv6, as far as I know.

Direct connection to 127.0.0.1 fixes this problem; but you can edit the hosts to resolve localhost to 127.0.0.1 , then localhost will work too:

• Open C: \ Windows \ System32 \ drivers \ etc \ hosts
• Delete the following line, if any: ::1 localhost
• Add the following line if not: 127.0.0.1 localhost

Answer 2

Using:

 $db_host = "127.0.0.1"; 

(or any other IP, for example 192.168.1.2 ), instead of the host name ( localhost ).

Answer 3

You can also look at this link: http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-name-resolve

- skip permission option