BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: maziken on January 25, 2010, 05:55:02 am

Title: mysql_connect error
Post by: 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.
Title: Re: mysql_connect error
Post by: maziken 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.
Title: Re: mysql_connect error
Post by: Khalem 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.
Title: Re: mysql_connect error
Post by: Arawacian on March 07, 2010, 03:30:41 pm
Additionally it seems that in Windows 7, Microsoft decided to not have localhost 127.0.0.1 in your hosts file anymore...
SimplePortal 2.3.7 © 2008-2025, SimplePortal