Is anyone familiar with the Dreamweaver CS3 MySQL connection function?
I created a MySQL connection in Dreamweaver to my local testing apache server on my local machine and accessed my MySQL databse tables successfully. However, when local testing was complete and I wanted to access my MySQL database on my dreamhost server the connection failed.
All I did was change the MySQL server address in the Dreamweaver MySQL Connection dialog box from 'localhost' to mysql.domainname.com (where domain name is the name of my remote host db which I created in my dreamhost account). All I get now is an #1045 access denied error from my IP address.
Has anyone got any idea why dreamweaver does not recognize and get authorization to connect to my dreamhost db?
Thanks in advance for any advice.