I have been fighting with my Dreamweaver MX connection to remote MySQL host for a couple of weeks now, and finally got it to work last night. Thought I would post a couple of the things I learned through the process. Hope this helps someone out there...

1) MAKE SURE...BY CONTACTING YOUR HOST (several times if necessary)...that your site account is set to receive remote connections. I could access MySQL through my host...I could set priveleges, users and create databases...however, the account was not set to receive remote connections. They set this up for me within a day of requesting it.

2) After your account is set, there may be some settings that you have to put in place such as, "host access". I never got a clear answer as to what I needed to put here as a "host address". However, putting "%" allows access from anywhere.

3) Getting the settings correct!! I read SOOO many things while trying to fix this. Different things. So, I can't guarantee these settings will work for you either. But, I will list my site settings below:

Remote Info:
Access: FTP
FTP Host: ftp.naturalimagesweb.com
Host Directory: public_html
(this is the folder that your site loads to)
Login: *********
Password: *********
Passive FTP Box is checked!

Testing Server:
Server Model: PHP/MySQL
Access: FTP
FTP Host: ftp.naturalimagesweb.com
Host Directory: public_html
Login: *********
Password: *********
Passive FTP box is checked!
Url Prefix: http://www.naturalimagesweb.com

MySQL Connections Dialog Box:
Connection Name: (whatever you name your connection)
MySQL Server: IP address
(see notes below)
User Name: (a user that has access to MySQL)
Password: *******
Database: (you have to specify one of your DBs)

**note on the MySQL server: some hosts have the MySQL server on the same server as your site. Some hosts have it on a separate server. Some hosts use the same username and password to access MySQL, and some hosts use different usernames and passwords. These are very important things to find out from your host. If they don't want to give you the answers, I would write to them everyday until they get tired of it and answer!! Most importantly, "localhost" DID NOT work for me with this remote connection when I put it in for the MySQL Server. Putting the IP address in was the last change I made that got me the connection!

4) If you haven't made a connection through any other program, try downloading MySQL Front and make a connection through that program. It's not a big program and is fairly easy to figure out. One hint...leave the port number at the default unless your host tells you that you will have to change it!

I am CERTAINLY not an expert on the topic of PHP/MySQL or on the topic of Dreamweaver. However, if anyone reads this and has any specific questions...feel free to contact me!! I couldn't have done it without the help of others, so I will gladly give back!!

Good day...
Tracy