Dreamweaver, can't connect to MYSQL Local Database on Mac

Yes, I tried that too. first of all and because the error was so specific, I tried that.Still no luck.

When you go to Site > Manage Sites > Select your site to edit.  On the next pop up, choose Servers.   You may see just one item or multiple.  If you have just one item and you are only using local, then you should have both local  and remote checked.  If you are set up for remote to be on a web server and testing local, then you should have two line items and one checked for remote and the other checked for testing.  Edit the testing server and make sure it maps to your site.

did all of that. I am well versed at that at least on the PC. I am learning there are a couple of connection files that dreamweaver no longer automatically adds, MMHTTPDB.php and mysql.php. looks like adobe is messing with what was a good thing.

I installed Mamp from a download. it installed to a different port but i changed it to port 80.
learning that the new dreamweaver CC has really been stripped down by adobe, and many are going back to cs6 because they have removed a lot of database options. People in the forums are really pissed.

i am running the latest OS, 10. something.

I found the answer to this myself but would like to share it with future generations...so-to-speak.

On a Mac, if you are having trouble getting your database to connect in Dreamweaver CC, it's probably not your fault. If you have set up your testing server and the page serves up normally in Live View or the browser, then the issue is probably because Dreamweaver isn't setting a couple of little files for you like it should do.

The file names are: MMHTTPDB.php and mysql.php and they are supposed to go in your folder _mmServerScripts  (only viewable through Finder or an FTP Program) . Dreamweaver automatically hides in in it's file system as it isn't needed on the remote server.

Most likely the folder is there but these files may not be inside.

I found a YouTube tutorial that showed where to find these but I followed the instructions perfectly and also searched my Mac files and they were not to be found anywhere.

So, I went to a PC that I had running CS6, found a random site that I could setup a database on, and did so. Dreamweaver generated the two files, I copied from my PC, placed them inside the needed folder on my Mac and all of a sudden, I am no longer getting the error that said I didn't have a testing server setup on my site.

Initially, Dreamweaver didn't even have "Databases, Server behaviors, and Bindings" available and I had to go into extension manager and install Deprecated Extensions.

I'm thinking....this is really stupid...what good is Dreamweaver if you can't use it for Dynamic sites??? It's like they don't want you to use databases with it?

Go ahead Adobe, mess with it like that and it will go the way of Front Page.

Wow, that makes sense.  Based on what you are saying, I found this from adobe that explains database function asp/.net/jsp, spry and cold fusion support are disabled but somewhat hidden and "go watch youtube" to turn them back one.

http://blogs.adobe.com/dreamweaver/

I am using PHP

and I saw that video, (mentioned it above briefly) and the problem again with that is, on my MAC, the two files he tells me to look for are not on my system in the place where he said it would be. Maybe they are there on the PC, I don't know.

so while the video was a little bit helpful, it all boiled down to those two pesky files that didn't get placed in that hidden folder on the root of my site. in _mmServerScripts folder.

Adobe is Deprecating Dreamweaver by deciding to Deprecate database features and access in it's program.

Thank you everyone!

I have never used Dreamweaver.  But I was thinking about the CS6 version because it does have some neat features.  When I looked at the Adobe pages and found only the 'cloud' subscriptions available, there is no way I would ever sign up for that.

i would try ebay and pick upa new copy from someone there.

I agree.  If you really use everything it is a good value.  But they price the individual products high enough it does not make sense to buy just one or two.    Out of the 7 major titles, you are bound to use 2 or 3 on a regular basis so that makes your $600 per year investment $200 per title plus some bonus free titles at your disposal.  

I think most of the product updates they do are just that, updates you would expect from expensive software.   Not complete versions.   There shouldn't be a need to update  every year at full price.

If you are a design shop that does print, Quark costs $1000 and $400 to upgrade.  With the adobe suite you get InDesign, Photoshop, Illustrator, Dreamweaver..... for $600 so in that regard it makes sense.

I just won't put my work in their 'cloud'.

The work stays local, the tool is also local but checks in with Adobe each time you launch it to see if you have a valid subscription.

If the subscription lapses, you still have all your files and work product locally accessible and editable with other software.

Not that I'm a 'total' cheapskate... but I paid $55 for a lifetime license to HTML-Kit about 8 years ago and I have fixed and / or repaired a lot of Dreamweaver code with it since then.  Yes, it would be nice to have it.  But I never had a job where it would pay for itself.