Hey guys,

Maybe you can help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I am attempting to setup DWMX 2004 so that it can connect to a MySQL database hosted on yahoo so I can do some PHP programming with it.

I am finally getting close as it appears to connect to the database - but then it comes back with this error message:

"Access Denied. The file may not exist, or there could be a permission problem."

I've only created one other PHP/MySQL site with DWMX - and I remember I had a bugger of a time getting it to connect correctly to the database then too <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> I have gone through everything listed under "testing server" in the bindings tab and I've tried several different things in the actual "MySQL Connection" under the "Database" tab.

If this helps any - the database privileges for the username/password that I am using are set to:
Global Privileges: Usage
Grant: No

Also - yahoo gives out this information (just now sure where I would put the "mysql" part in the Connection window from the Database tab, or if it would go somewhere in the "testing server" area of the "bindings" tab)

You can create custom PHP scripts to access your database. Below are a few lines of PHP code you can use to access your database.

&lt;?php
$link = mysql_connect("mysql", "USERNAME", "PASSWORD";
mysql_select_db("DATABASE";

$query = "SELECT * FROM TABLE";
$result = mysql_query($query);

while ($line = mysql_fetch_array($result))
{
foreach ($line as $value)
{
print "$value\n";
}
}

mysql_close($link);
?&gt;

Please note that you must replace USERNAME and PASSWORD with your database user name and password. You must also replace TABLE and DATABASE with the valid table and database names from your database. The address of the MySQL database server is simply mysql; it is not necessary to include a port number.

So - anybody out there feel they might be able to help me get this thing working? <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

Thanks,
Tracy

Apparently Yahoo is not setup to allow remote access to their database <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> So I fixed it by setting everything up locally <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>