Good Day,
I am following Allen Kents great tutorial on using DWMX for PHP & MySQL programming, but I have a problem - <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Problem is this - The server that I am using is a remote server (it is on my own home network) I can SSH , FTP, and run phpmyadmin (have created the dmxzone db, and user as per the instruction)

When I connect to the db after clicking on the + sign, enter the username and pwd - and also the MYSQL server.

This is where I am getting into trouble.
I created my dmxzone user with % instead of localhost (as I understood it - the % is for remote access - what I am doing - or am I completely wrong?).

Now in the MySQL server - I enter my server name in the form of name.name.name I get an error trying to connect to the db's when I hit the select button. I also try localhost - same error, try ip address and same error - My firewall is set to forward port 3306 (which I believe is the Mysql remote port) to my server.

Boy - Hope that I have explained enough correctly here to get make my problem understood.

Thank you Very much in advance for any help/suggestions

Andrew

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Good Day,
I am following Allen Kents great tutorial on using DWMX for PHP & MySQL programming, but I have a problem - <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Problem is this - The server that I am using is a remote server (it is on my own home network) I can SSH , FTP, and run phpmyadmin (have created the dmxzone db, and user as per the instruction)

When I connect to the db after clicking on the + sign, enter the username and pwd - and also the MYSQL server.

This is where I am getting into trouble.
I created my dmxzone user with % instead of localhost (as I understood it - the % is for remote access - what I am doing - or am I completely wrong?).

Now in the MySQL server - I enter my server name in the form of name.name.name I get an error trying to connect to the db's when I hit the select button. I also try localhost - same error, try ip address and same error - My firewall is set to forward port 3306 (which I believe is the Mysql remote port) to my server.

Boy - Hope that I have explained enough correctly here to get make my problem understood.

Thank you Very much in advance for any help/suggestions

Andrew
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Okay - I am a certified Idiot.
All I had to do was put localhost in the MYSQL server box - and that worked, I guess when the testing server is setup, it already knows where to go to get the database.

THanks