Avatar of edvinson
edvinsonFlag for United States of America asked on

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

I have never had a problem connecting to database on my PC, but setting it up on a Mac.
 I have  Dreamweaver CC

I have tried every imaginable setting, connection string, etc.

the error tells me there is no testing server on the machine or it doesn't map correctly.

Screenshot attached.

Thank you
Ed Vinson
Screen-Shot-2013-08-26-at-9.19.5.png
Screen-Shot-2013-08-26-at-9.19.5.png
Mac OS XAdobe DreamweaverMySQL Server

Avatar of undefined
Last Comment
Dave Baldwin

8/22/2022 - Mon
SOLUTION
Jason C. Levine

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
edvinson

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

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.
ASKER
edvinson

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
SOLUTION
Dave Baldwin

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
edvinson

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.
ASKER
edvinson

i am running the latest OS, 10. something.
ASKER
edvinson

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Scott Fell

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/
ASKER
edvinson

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.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
edvinson

Thank you everyone!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Dave Baldwin

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.
ASKER
edvinson

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

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Dave Baldwin

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

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.
Dave Baldwin

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23