Author Topic: mysql_connect error (Read 2631 times)

maziken · « **on:** January 25, 2010, 05:55:02 am »

I searched the forums and found the other thread on this but it did not solve my problem. This is the message I keep getting. I tested to see if I can login to the SQL server using the created username and it is working fine. Any ideas?

Quote

Curl extension loaded

Warning: mysql_connect(): [2002] A connection attempt failed because the connect
ed party did not (trying to connect via tcp://localhost:3306) in C:\Bebot\Sourc
es\MySQL.php on line 129

Warning: mysql_connect(): A connection attempt failed because the connected part
y did not properly respond after a period of time, or established connection fai
led because connected host has failed to respond.
in C:\Bebot\Sources\MySQL.php on line 129
MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as
user root!
A connection attempt failed because the connected party did not properly respond
after a period of time, or established connection failed because connected host
has failed to respond.

maziken · « **Reply #1 on:** January 25, 2010, 06:08:28 am »

Ack. I fixed it myself. >.<

Apparently, the latest version of PHP coupled with the latest version of MySQL doesn't like "localhost" as a valid server name. Changed it to 127.0.0.1 and it connects just fine. This is with Windows 7 as an OS.

Khalem · « **Reply #2 on:** January 25, 2010, 09:44:31 am »

The difference between localhost and 127.0.0.1 for MySQL is that localhost will use a pipe/socket connection while 127.0.0.1 will use a TCP/IP connection.

Not sure if the default MySQL settings now come with piping disabled by default.