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
LVL 1
edvinsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineNo oneCommented:
Doesn't MAMP use "localhost" instead of 127.0.0.1?
0
edvinsonAuthor Commented:
Yes, I tried that too. first of all and because the error was so specific, I tried that.Still no luck.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

edvinsonAuthor Commented:
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.
0
Dave BaldwinFixer of ProblemsCommented:
Which version of OS X are you running?  Are you using the built-in install of Apache (which is usually 'localhost') or did you install MAMP at a port other than port 80?  Did you install MySQL on that machine?
0
edvinsonAuthor Commented:
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.
0
edvinsonAuthor Commented:
i am running the latest OS, 10. something.
0
edvinsonAuthor Commented:
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.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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/
0
edvinsonAuthor Commented:
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.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
It does make sense.  Going back to the MX days when they even had .NET db log in scripts that were later taken out... you did not have blogger or tumblr being used for websites and there was no such thing as squarespace or weebley.    

Now I think the majority of people that want an easy site are using the likes of wordpress, tumblr and squarespace.  Most everybody else is going to MVC and end points.   I would imagine their thought is the amount of users relying on those functions are decreasing rapidly and the amount of people that will rely on css, html5 and jquery are increasing.  

I am a mac  user as well and use submlime text and dreamweaver cs5.5 and had used mx and cs3.  If I had to buy something similar, I think I would look at http://panic.com/coda/  The only compelling thing about adobe is the big bundle with photoshop, illustrator and the video software.  I still use cs3 for those.  I did just find out the newest photoshop has a feature to go from shape to css3 styles.  That sounds pretty cool.  

At least you found it.  Good to know for the future.  I would bet in whatever the next version they come out with that may go away completely.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
edvinsonAuthor Commented:
Thank you everyone!
0
Dave BaldwinFixer of ProblemsCommented:
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.
0
edvinsonAuthor Commented:
i would try ebay and pick upa new copy from someone there.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.
0
Dave BaldwinFixer of ProblemsCommented:
I just won't put my work in their 'cloud'.
0
Jason C. LevineNo oneCommented:
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.
0
Dave BaldwinFixer of ProblemsCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Mac OS X

From novice to tech pro — start learning today.