collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: MySql Issue  (Read 1513 times)

0 Members and 1 Guest are viewing this topic.

Offline GBH

  • BeBot Hero
  • ******
  • Posts: 69
  • Karma: +0/-0
MySql Issue
« on: December 04, 2010, 01:29:26 pm »
Hi,

I've had a working bot without any problems for ages. I've just completely re-installed everything including PHP and MySql only I'm getting the following error

Code: [Select]
Curl extension loaded

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

Warning: mysql_connect(): 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.
in H:\Bebot\Sources\MySQL.php on line 129
MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as user botuser!
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.

I can log into the database using EMS SQL Manager Lite using the "botuser" account and I have access for everything. I've rechecked and re-done my grant privileges to make sure I have full access to the DB. I can browse the DB without any limitation. The service is clearly running or I wouldn't be able to access it at all.

I've re-installed the DB twice and it's had no effect.

Anyone got any ideas why this is happening?

G

Offline GBH

  • BeBot Hero
  • ******
  • Posts: 69
  • Karma: +0/-0
Re: MySql Issue
« Reply #1 on: December 04, 2010, 06:02:33 pm »
OK figured it out (well technically someone in the guild did but I'm sure I'd have got there eventually ;))

In Windows 7 Hone Premium edition, 127.0.0.1 is not mapped to localhost in the /Windows/System32/Drivers/Etc hosts file. It's commented out and makes a note that it will be picked up by DNS. Uncommented it and bam, bot connected straight away.

What a crock of shit. Thats all I have to say on it.

Anyway all sorted and the bots back up.

G

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 514
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal