![]() It’s tedious having to type this out every time. In this folder we’ll have to execute several commands, each a folder or so deep. In OS X (and many other *NIX type distributions), MySQL is installed at /usr/local/mysql. This step is optional but highly recommended should you wish to do any command line hacking that involves MySQL. Adding easy command line access to MySQLīefore we can start using MySQL with fancy GUI tools, it’s probably wise to make it easily accessible from the command line as well. You’ll need to provide your password (for Administrator privileges and all). Should this happen, start the daemon via the command line manually, like this: // starting the daemon manually At times however, that fancy button is greyed out, which means that the Launch Daemon isn’t running. If you ever want to start/stop MySQL, this is the most convenient place to do it on your Mac. Tick the box that reads “automatically start MySQL server on startup” if you want that behaviour. Start MySQL using the preference pane I’ve just mentioned. Take a look under (Apple Logo) – System Preferences and see if you can find the MySQL Preference Pane. We’ll take care of that in the next step. When the installer has finished, MySQL is installed on your system – but of course it’s neither running nor configured yet. You’ll probably want the DMG Archive equivalent to the version of OS X you’real running (this screenshot was taken in November 2015, things may have changed since then):ĭouble-click the file and you’ll be guided through a standard OS X installation. Pick a platform from the drop down menu (Mac OS X).Īgain there are several versions you can download. Hunt for something called the Community GPL Downloads, and for a section called MySQL Community Server. If that link isn’t working, head over to and find the Downloads section. You’ll find several packages at the MySQL website in the downloads section: These instructions will work on Yosemite and El Capitan (I’ve tested it on both systems – in fact that’s part of why I’m writing this, so that I can remember for next time). In this article I’ll focus on the latter, and I’ll also talk you through how to add MySQL to the PATH variable and how to secure MySQL to keep the evildoers away from your server. I recommend the dedicated installer because it’s the only package that will also add a convenient Preference Pane for starting and stopping the service. or use the dedicated MySQL installer package (recommended).use a nifty script courtesy of Mac Mini Vault ( ).I have spent two days reading and trying all the standard resolutions.There are several ways to install MySQL on your Mac, for example: Have you any special knowledge of how to MODIFY Dreamweaver connectivity to see what every other mysql product sees instantly? Version after version of Dreamweaver NEVER gets this issue permanently resolved. I say this because I have worked with Dreamweaver since the 90’s on Windows machines. Only Dreamweaver is too stupid to find it. I now need ONE solution that FORCES Dreamweaver to use the proper connection string, to go looking for the same socket or data connection method that works by default. I put that folder into the MAMP installation to see if I could figure out how to use them.īut I can’t find information on how to set up HTTP tunnel.Īt any rate, PHPMyAdmin and Navicat Lite can connect to my mysql databases created inside MAMP. In the Navicat Lite download it included a folder with connection scripts for setting up HTTP Tunnel. I see in the connection files in Dreamweaver that in the MAC folder it says that it is going to use HTTP as the connection method if it detects that it is on a Mac computer. either localhost or localhost.8888 works, depending on whether I have started MAMP in 80 & 3306 or 8888 & 8889 for apache & mysql. The Dreamweaver site shows that my local and testing server urls are working. I have all the Dreamweaver site files in the Mamp htdocs folder. I have removed connections and started over. etc.īut every single connection that I create or try to re-use from days ago fails. I have changed PHP and Mysql ports back and forth between 8888 & 8889 to 80 & 3306, I have done terminal sudo commands to create a “symbolic” link between the mysql socket in MAMP in the Application folder etc. I have spent two days going from “solution” to solution. ![]() ![]() Navicat Lite which I just installed today sees my mysql databases perfectly and immediately.ĭreamweaver CS4 fails in every possible way to see the tables. Mamp’s PHP Admin sees databases just fine. I reinstalled MAMP after saving the db folder and reinstalling it. No more repeated crashes.īut I could not get the Dreamweaver connections actions to see databases any more. I had to get rid of a Configuration-1 that had formed. ![]() My Dreamweaver CS4 was also starting to crash. 2 days ago on my MacPro OS 10.6.8 I uploaded the latest Adobe updates. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |