I'll try and explain this the best I can, I'm a complete newbie so forgive me if I'm stating the obvious.

I'm using Dreamweaver MX to connect to a MySql server on my local computer. I have successfully set up PHP and MySQL on my Mac with OS X. And on my PC with Windows 98. Everything works as it should.

What I'm trying to do is set up my mac at home that runs system 9.2, so i can't install MySql on it ect. So, in Dreamweaver I'm configuring the test server to be my web hosting account instead of locally. My webhosting account is Unix, using a Cobalt server and I've been set-up with a MySql database. I've added some data and I can pull this into a php page that I ftp to my hosting account with no problems. But, when I try to connect to the database through dreamweaver It fails. It says that it connects to the host OK, but then It says: "FTP error occurred - cannot make connection to host." Also If I try the "live data" in dreamweaver I get the error message "An error occurred while requesting the document from the testing server: Found The document has moved here".
My site definition in Dreamweaver is set up like this:
Server Model: PHP/MySQL
Access: FTP
FTP host: my domain name.co.uk
Login: My user name
Password: My password
URL Prefix: my domain name.co.uk/

I then try conecting through dreamweaver like this:
Connection Name: Test_Conn
MySQL server: localhost
User Name: my user name
Password: my password
database: my database

I have an idea the problem is something to do with my domain name being an alias, I've tried putting in the IP address of my hosting account though and that doesn't work either.
Any one got any ideas. Thanks in advance.