PLEASE help me connect Remotely to mysql db !

[Delpiero]

Hi Gang,
I could really use some help, i'm trying connect to a mysql db that is being hosted for me on the web. I can connect thru dos but I would like to connect using MYSQLMANAGER, MYSQLCLIENT or any GUI that will allow me to work remotely. I'm having problems configuring it and i've tried reading instructions and it looks really basic but its just not working. I have downloaded the odbc just to see if that would help but it hasn't. Any help would be wonderful, if anyone has any ideas i'll give you some more information if needed.
Thanks a bunch,

Troy

 

[piti]

aren't you behind a firewall that blocks the mysql port 3306?

 

[Delpiero]

Well I can ping to the server and also connect thru telnet, i'm just having problems connecting thru mysqlmanager or any gui and dreamweaver. I'm thinking that maybe i haven't been granted remote privileges or something like that.

Troy

 

[danielhozac]

Execute this query from a command line:

SELECT Host FROM mysql.user WHERE User='YOUR USERNAME';

If there is a % there, you should be able to connect from anywhere, if there is a hostname or IP, you would only be able to connect from that hostname or IP. //Daniel