Ok sorry bout the delay, have had flu over here and it kicked me in the ass for a while.
I looked at my setup and assuming your mysql and php are working, and that your machine has access (have you used a graphical client like mysqlfront and checked????). I'm assuming you have but being thourough. I next went into dreamweaver and did the following to connect :
1) Define a site, this comprises the following :
Choose php and mysql as a server technology
Next set up your paths, mine point to w: which is a mapped drive to the redhat box with the html and apache on.
Next it asks how to connect, i do local lan and then point to w: again (w: for web lmao).
For the url i give it http://redhatserver/
I dont enable check in / out, but thats preference.
2) In DW XP (Important, allthough i've used 4 these instructions were for my XP setup) get the application tab up on the right, and then go to bindings, click the + button !!!
Choose recordset, and then follow these settings :
Name : Anything you want
Connection : Hot define and then fill in your details as follows :
name : name of your connection (anything)
mysqlserver : name of your server ie fred, or redhat
username : user with % access in mysql
password : obvious !!! see above user details
database : name of previously setup db
where it now said connection you should set it to the one you just setup above.
you should now be able to select a table from a dropdown list
this is now your connection working !!! or should be.
Your db, db user and tables MUST be presetup, DW-XP will not do this for you as far as i know..
Hope this helps more, let me know how you go on, this is turning into a vendetta now lol, i remember how i started, frustrated the hell outta me for ages hehhehe