OS X might be the easiest platform to install MySQL on. To do so, simply download the MySQL installation package from the MySQL Download site. I like to use the third link (the DMG). Once downloaded, run the package. The package will ask you a few questions and you can easily just select the default choice during the installation process. Once installed, you’ll be prompted that a temporary password has been used for your MySQL instance. The password will get you in the first time, so you can change it. Once you have documented the password, open System Preferences and click on MySQL in the bottom row of System Preference Panes. Click Start MySQL Server and then when prompted, authenticate to the system. If you’d like to do this programmatically and don’t need the System Preference pane, you can do so with homebrew. If you have homebrew installed, simply run the brew command with the install verb and mysql as the package:
brew install mysql
Whichever way you install SQL, once installed, you’ll want to set the root password to something other than the intuitionally difficult to remember password provided at install time. To do so, first connect to the mysql instance now running on your computer. As the tools are installed in /usr/local/mysql/bin, run the following: /usr/local/mysql/bin/mysql -u root
- Mac mini introduced in early 2009 or later iMac introduced in mid 2007 or later Mac Pro introduced in early 2008 or later Xserve models introduced in early 2009. To find your Mac model, memory, storage space, and macOS version, choose About This Mac from the Apple menu. If your Mac isn't compatible with OS X Yosemite, the installer will let.
- The free download for the Mac is the MySQL Community Server edition. Go to the MySQL website and download the latest version of MySQL for MacOS. Select the native package DMG archive version, not the compressed TAR version.
MySQL is a free relational database, now owned by Oracle. Installing MySQL. Here are instructions for setting up a 64-bit MySQL on Mac OS X, tested August 2010 with 10.6.4 Snow Leopard (MySQL 5.1.49), October 2012 with 10.8.2 Mountain Lion (MySQL 5.6.17), April 2014 on 10.9.2 Mavericks (MySQL 5.6.25), Oct 2015 on 10.10.5 Yosemite (MySQL 5.6.25). MySQL Workbench Prerequisites for Mac OS X Yosemite. June 02, 2015 11:34PM. Downloads; MySQL Community Server; MySQL NDB Cluster; MySQL Shell. Download the Yosemite installer from the Mac App Store and make sure it’s in your main Applications folder (/Applications)—it’s called Install OS X Yosemite.app. Connect to your Mac a.
Then, set the password using the ALTER statement along with the USER option and then the username followed by IDENTIFIED BY and ultimately the password, as follows: ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysupersecretpassword';