I am testing out the MySQL connection in Dreamweaver 2004. I am running through the steps in the Dreamweaver tutorial, making changes necessary to get their test database running on Dreamhost. The DW instructions are Windows server centric.
I got my database set up on the DH panel, not my first MySQL database by the way, so you'd think I'd be able to figure this out. I had to call my new database ykfpmotors, since someone already has used DW's name TrioMotors, so somebody has probably done this DW tutorial before on DH. I added tables and populated them running DW's insert.sql script. I can connect to my DW tutorial database with "mysql -u ykfpdata -p -h ykfpmotors.ykfp2.dreamhost.com ykfpmotors". And I can find my new database with phpAdmin pointed at http://www.ykfp2.dreamhost.com/dh_phpmyadmin/ykfpmotors.ykfp2.dreamhost.com/ . But I can't get hooked up with DW's database connector. I get a popup forms titled "MySQL connection, filled in the boxes:
Connection name connTrio
MySql server: ykfpmotors.ykfp2.dreamhost.com
User name ykfpdata
password my password
Database: ykfpmotors but also tried the select button but I get the same result: 503 service not available
You'd think I mistyped something but I've gone back over it and also tried setting up the MySQL connection on my Windows XP from Microsoft Data Access- ODBC administrator. I filled out the pop up form to configure my MySQL ODBC 3.5.1 Driver to use Server ykfpmotors.ykfp2.dreamhost.com and user ykfpdata and database ykfpmotors, but testing this I get "Access denied for user: 'firstname.lastname@example.org' (Using password: YES)"
Where is my typo?