Local testing server connection problem

[bcoppola]

I have posted this in the MAMP and Adobe support forums but as no answers have been forthcoming there, perhaps someone here can help. I'm aware that DW is not an ideal solution but it's what I have. I try to work in code view for changing the odd variable or define, and I like to be able to preview the look of my pages before saving them. At least I would if I could get this problem solved.

 

I have set up a local testing server on my Mac running OSX 10.6.7 using MAMP 1.9.5 and Dreamweaver CS4 to test my osCommerce store (I like to see what's happening visually, even if I just change a small variable in the code). Although I have imported the store database from my remote server, and the connection tests in the DW Database window to the store, mysql, and information schema databases in Dreamweaver are successful, I still get "Unable to connect to the database server!" when I try to preview a .php page with DW's Live View or with a browser. I'm using the correct ports in my site definition (8888 and 8889). MAMP shows Apache and MySQL running, of course. Have tried logging in as root and as my usual username with the correct passwords. Everything seems to be right...but it's still wrong.

 

Do I also need to import the mysql and information schema databases from my remote server to replace the ones that came with MAMP? If so, where do I put the information schema db? Although it shows as a database in PhpMyAdmin, I don't see a folder or doc by that name anywhere in MAMP - it must be buried pretty deep! (I did find a file called information_schema_relations.lib.php in MAMP/bin/phpMyAdmin/libraries. Is that it?)

 

Or is it something else entirely?

 

Note that though I'm a fairly savvy user (IMHO), I am not a developer or coder. Strictly a GUI/static design guy with a liberal arts education. Keep the answers simple and in plain English, thanks. :)