Connection to an external mysql server failing

Anon

i need to connect to a mysql database external to my comp. when i set the script up to do this, i get:
Warning: MySQL Connection Failed: Access denied for user: 'gamesmaster@202.10.82.84' (Using password: YES) in C:\PUB\HTTPD\HTDOCS\test.php on line 9

the script is as follows:

Anon

btw, 202.10.82.84 is my own ip address - for some reason it's looping back to localhost.

Anon

Did you add your host and username to the mysql privileges tables?

Anon

yep, that's all done

Anon

Well the mysql server is clearly saying that the permissions
are not correct. :-)

Just brainstorming (no offense if I ask "stupid" questions)
Are you positive about the username/password and hostname?
Is the username and password on mysql setup for your hostname/ip?
Can the MySQL host resolve your IP#?

Anon

well, i'm using the username and password i was given, so i assume it's all alright on their end. dunno about ip permissions, i'll ask.

um, the point is, it's not even trying to connect to the external server - it's looping straight back to localhost and ignoring my settings (of course it can't connect to localhost, i don't have a mysql server on this comp, that's where the permission denied setting is coming from)

Anon

It's not looping back to localhost

Access denied for user: 'gamesmaster@202.10.82.84'

this means that user "gamesmaster", connecting from "202.10.82.84" is not allowed to connect to the server.

The MySQL server needs to have a privileges entry to allow gamesmaster to connect from 202.10.82.84.

Anon

actually, as i said in the 2nd post (cause i forgot to in the first one), 202.10.82.84 is my comps ip. i put this on a different server (fsgs.com), and it attempted to connect to the localhost there, too.

sorry if i didn't clear that up earlier - the mysql server is at venus.actrix.co.nz (203.96.16.106), which is why the script has it as the connection.

and access is denyed because on my comp (which is at 202.10.82.84 and it's looping back to, instead of venus.actrix.co.nz), there's no mysql server, let alone an account called "gamesmaster"

Anon

I'm not making myself clear am I :-)

The error message you got did NOT come from your localhost.

When you connect to a mysql server, php first tries to only connect.
Then it tries to login using username and password.

In MySQL, access rights are defined by username, password and hostname.
This hostname is not the hostname of the mysql server, but the hostname of the server that wants to connect to the mysql server.

You say there is no mysql running on your machine, so php would not be able to connect to localhost at all, so there would be a "cannot connect" error if your php script tried to connect to your localhost.

Intead, you get an "access denied" message, which means that php was able to connect to the mysql server 203.96.16.106, but the username/password was not correct for your host (202.10.82.84).

Anon

AHHHHHHHHHHHHHH click

i thought the ip it was spitting back was the ip of the mysql - gah, curse ie and it's user:pass@ip.connecting.to format =)

cheers guys, and thanx for bearing with me.

/me feels like such a fewl

Anon

I'm having a similar problem. However, I am trying to connect to an external mySQL server, and I have specified the following:

sAdoConStr = "driver={MySQL};SERVER=www.emmgee.com;Database=CousinFinder;UID=myUserID;PWD=myPassword;"

(I'm using Visual Basic 6.0)

of course i replaced myUserID and myPassword with the appropriate values in my script. the error I am getting, is that it cannot resolve the host:

"Specified SQL server not found."

What am I doing wrong?

Thanks!