A few years ago we started writing scripts that help install MySQL on OS X. In OS X 10.6 and prior, MySQL was included with the “Server” version of the OS. With the move to Server.app, Apple removed MySQL. Which coincidentally is not long after Oracle acquired Sun which included MySQL. MySQL had a GUI installer for OS X that worked well, but was missing a few things that made it ready to work with Apache/PHP out of the box. Our installer took care of those items as well as set the root password randomly. The default install has root enabled without a password. We took the installer one step forward by adding features for installing a modified MySQL configuration file, and Sequel Pro (a GUI front end for MySQL). Then Yosemite was released recently and our installer had a few issues.
To be able to install and run MySQL Workbench on Windows your system needs to have libraries listed below installed. The listed items are provided as links to the corresponding download pages where you can fetch the necessary files. Microsoft.NET Framework 4.5. SQLPro for MySQL is the Premier application for editing and viewing MySQL databases on mac os x. SQLPro for MySQL. SQLPro for MySQL. Download; Buy; A simple, powerful MySQL manager for macOS Download (also available on the Mac App Store). But still supporting Mojave, High Sierra and Sierra. Intuitive interface. Coming from Microsoft SQL. Mac Sierra Iso Download For Pc Onedrive For Business Mac High Sierra Usb Display For Os X Instruction Macos High Sierra Plex Wake For Network. Qgis For Mac Sierra Mysql Tools For Mac Os X Html For Mac Os X Our popular MySQL Installer for OS X 10.8 Mountain Lion has been upgraded to support OS X 10.9 Mavericks. The installer script is a part.
The upgrade to Yosemite did spring cleaning to OS X. There were long outstanding bugs that were resolved and deprecated commands/functions that were finally removed. MySQL had been using a StartupItem configuration to allow an end user to easily set MySQL to start on boot. This setup has been out of date since the OS X 10.4 days. Yosemite will not autostart via a StartupItem. You can easily write a Launchd plist file to auto-start MySQL, but the nice MySQL preference pane that allows a user to turn MySQL off and on again would not function. There is a supporting script from MySQL that handles the start/stop/status functions for the preference pane. What we did in our latest installer is created a Launchd plist that looks for networking to start up, and when ready, use the MySQL support script to start MySQL. This allows MySQL to start on boot, and still retains all use of the MySQL Preference pane.
We also specifically set the MySQL installer to not even attempt to install the Startup Items. Our latest version also should fix the ‘pid could not be found/error not running’ error that some people experienced in the past! (Edit: maybe not every pid error scenario)
The code is all up on github – We have a page that describes each script and provides the important links: http://code.macminivault.com/
- Mysql for mac free download - WinZip Mac, Avast Free Mac Security, AVG AntiVirus for Mac, and many more programs. Access NTFS drives in macOS Sierra. Free to try User rating.
- Macworld also has bootable-install-drive instructions for: mac OS High Sierra (10.13) El Capitan (OS X 10.11) Yosemite (OS X 10.10) Mavericks (OS X 10.9).
To install MySQL copy and paste this into Terminal (Be sure to read the READ ME first):bash <(curl -Ls http://git.io/eUx7rg)
The great thing about hosting our scripts on github, is that others can easily follow our development and provide input or code that we may merge into our codebase. Star/Watch our Mac-Scripts repo and be sure to let us know of any issues or requests on Github!
Update: We have an updated post that shows how to install MySQL 5.7 on macOS Sierra.
This should be really straightforward, but I found myself googling around. I wrote a recent post about how to create a web app with the Laravel PHP framework but connecting to the database was tricky.
First step, find out what version of OS X you are running. Click the apple icon in the top right corner of your screen and click “About This Mac”. I got something like this:
Next step, head over to the MySQL downloads page.
So with my computer I am running 10.11 and we want the .dmg file. Download Mac OS X 10.10 (x86, 64-bit), DMG Archive. Then you get to this lame screen:
MySQL is free and open source software (FOSS), you do not need to sign up or create an account. Click “No thanks, just start my download”. I let the download go directly to my “Downloads” folder when prompted, though you could place it anywhere. The download will take some time because it is 350mb, go get a coffee. Once the download is complete. Double click the file and a screen like this will open
Double click it and go through the install process.
When I did it I got an alert box:
Add to path. This went in ~/**.zshrc **because I am using ZSH. If you are using bash for terminal (the default on OS X) this will be the ~/.bashrc file or ~/.bash_profile. This post explains the difference between the two files.
Add the mysql download to your path so that you can use the “mysql” command from the command line.
Then test it out:
Now that we have MySQL installed and accessible from the Terminal, it’s time to connect to the database and start the MySQL server. Let’s log in as root user (root@localhost) and use that funky password that popped up in the alert window after our install. In the above case it’s #fW&tYe?<8?w
Great! Now we can create databases and run SQL queries right from the command line. That’s an awesome start, but there’s no way anyone is going to remember that password, nor is it enjoyable to type in every time we want to run MySQL. The full docs on changing passwords are here. For OSX you can run the command:
The PASSWORD('root') sets my password to “root”. Easy to remember right? You can set your password to anything you like, such as PASSWORD('myN3wp@Ssw0rd').
To stop the server in the terminal run control + D. Congratulations! You’ve installed MySQL on OSX, made it accessible from the command line and updated your password for the root user.
To start setting up a Laravel application and connect to a database using Sequel Pro you can follow my next tutorial:
Thanks for reading!
Update (9/16/17): Expired passwords
When trying to login to MySQL on OSX recently I ran into the following error:
There are a lot of StackOverflow threads and articles about this, many require writing SQL commands, though that was difficult for me without access to the terminal. In order to alleiviate this I found this SO answer that saved me:
Update 03/29/18:
- Helpful steps for Install MySQL on macOS Sierra as a gist link.
Mysql For Mac Os
Update 05/14/19:
Mysql Server Mac
- I recently ran into an error when trying to fire up the MySQL shell:
Mac Start Mysql
I found the solution in this homebrew issue. Create an empty directory for this path: mkdir /usr/local/etc/my.cnf.d