Author Topic: FIXED: Mysql connection failed (Read 6743 times)

davidfury · « **on:** October 21, 2009, 04:04:54 pm »

i cant seem to connect the bebot, this is the messege i get:

Curl extension loaded

Warning: mysql_connect(): [2002] A connection attempt failed because the connect
ed party did not (trying to connect via tcp://127.0.0.1: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

Fatal error: Call to a member function log() on a non-object in C:\Bebot\Sources
\MySQL.php on line 164
i really apreciate any help i can get.

please

Getrix · « **Reply #1 on:** October 21, 2009, 04:31:06 pm »

And you are having a MySQL server installed on that machine with database and user?

davidfury · « **Reply #2 on:** October 21, 2009, 05:37:37 pm »

yes, i have it installed, Mysql, 5.1.
i did it all according to the Bebot Wiki guide.

clashbot · « **Reply #3 on:** October 21, 2009, 05:42:40 pm »

check you mysql conf file to make sure it is correct with the values that you used to create the DB

Khalem · « **Reply #4 on:** October 21, 2009, 09:15:33 pm »

Check firewall settings as it could be blocking incoming traffic to your MySQL server.

Second, you could try using localhost instead of 127.0.0.1 for your MySQL server.

davidfury · « **Reply #5 on:** October 21, 2009, 10:09:57 pm »

i tried, i used localhost instead, and yea i checked the file so many times, its all correct, and i have no firewall, i even port forwarded ports 3306 and 3307

Getrix · « **Reply #6 on:** October 22, 2009, 07:58:37 am »

See if you could find "mysql-cli.exe" or "mysql.exe" (Not sure whats the name of that client file on Windows) in your MySQL bin folder.
execute that using "cmd" with:

Quote

mysql --user=user_name --password=your_password db_name

EDIT:
Found a installation on one of my computers.
The client name is "mysql.exe".
You could also try the files "mysqlcheck.exe" "mysqltest.exe" and see if anyone of them gives you a result that you can connect to your DB..

davidfury · « **Reply #7 on:** October 22, 2009, 05:50:28 pm »

i get error access is denied for user Davidfury@localhost, using password=yes.
although I'm using the correct user and password.

I'm very very sorry to bother you guys, but I'm really trying hard to get this bebot working.
we really need it.
anymore help is really appreciated.

i even tried opening CMD as admin.

snyder · « **Reply #8 on:** October 23, 2009, 10:22:52 am »

did you try with root username and password you put at instalation?

davidfury · « **Reply #9 on:** October 24, 2009, 06:51:42 pm »

ok i fixed it, apearantly i had 2 Mysql running, the old one and the new, even though i removed the old one. but it was still in my registery files, so i removed them all from the registery, and installed the latest one again, and now its working.
=)
now i dont know if i should remove this post or keep it, i will leave this to an admin to decide, i was gonna remove it but i thought someone with the same problem might need it.
thanks alot for your help guys, i really apreciate it.
=)