I’m setting up a mysql database connection in Dreamweaver CS5.5. Here’s the settings that worked for me:
In the MYSQL Connection:
Mysql Server: xxx.xxx.xxx.xxx – the ip address of your hostgator mysql connection
Username: youraccount_yourMysqlUser
password; xxxxxxxx
Database: youraccount_yourdatabasename
The above is what I tried first – but it didn’t work. Then I did some searching and found these two references and links:
<a href=”https://forums.adobe.com/message/4791755″>https://forums.adobe.com/message/4791755</a>
<a href=”https://www.highdots.com/forums/macromedia-dreamweaver/_mmserverscripts-mmhttpdb-php-162885.html”>https://www.highdots.com/forums/macromedia-dreamweaver/_mmserverscripts-mmhttpdb-php-162885.html</a>
Using this information I made a testing server entry in DW that had as the web url my Hostgator url:
https://skts.hostgator.zaks.com
And then the database binding started to work. Â Go figure. I’m not asking why. It just does.
P.S. I highly recommend Hostgator, the live chat is very helpful, I much prefer that over sending an email and hoping you hear from someone soon.