General > Helpful posts

MySQL n00b help.

<< < (3/9) > >>

belatu:
it seems that it was a problem of ; missess ; ; ; ;

anyway the servers are down

i will try later

Arawacian:
Think I found the solution to an issue on windows 7, I am not completely noob, but I almost broke my skull over the fact that I couldnt get the bot started . It had the famous standard problem connecting to MYsql

--- Code: ---MySQL ERROR(# 1) on query: Cannot connect to the database server at localhost as
 user xxxxxxxx!
Access denied for user 'xxxxxxxxxx'@'localhost' (using password: YES)
--- End code ---
So thinking i made a mistake in either DB creation or user addition I checked.... and checked... and uninstalled.... reinstalled... and checked and still not working...

AT work now i realize and found additional evidence that in windows 7 the line for 127.0.0.1 localhost is not included in your hosts file anymore...

Gonna check when I get home if this was the issue.

uncommenting the 127.0.0.1 localhost line in the hosts file resolves the issue for win 7

dragonjr:
would i have to make that change for vista?

TBK:

--- Quote from: dragonjr on October 05, 2010, 01:18:24 am ---would i have to make that change for vista?

--- End quote ---

Windows key + R, type "%windir%\system32\drivers\etc\hosts", open the file in notepad

Then uncomment the two lines, so you end up with the same result as displayed below.

--- Code: ---# localhost name resolution is handled within DNS itself.
127.0.0.1       localhost
::1             localhost
--- End code ---

Killaah:
Hi guys,

Just trying to setup bebot for my guild in AOC. Everything appears to be fine but im stuck on this error.

[10-Nov-2010 23:15:41] PHP Warning:  mysql_connect(): [2002] A connection attempt failed because the connected party did not  (trying to connect via tcp://localhost:3306) in C:\guildbot\Sources\MySQL.php on line 129
[10-Nov-2010 23:15:41] PHP 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 C:\guildbot\Sources\MySQL.php on line 129

ANy suggestions?

Cheers in advance

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version