#DOWNLOAD MYSQL FOR MAC FREE HOW TO#
#DOWNLOAD MYSQL FOR MAC FREE INSTALL#
#DOWNLOAD MYSQL FOR MAC FREE ARCHIVE#
#DOWNLOAD MYSQL FOR MAC FREE FULL#
#DOWNLOAD MYSQL FOR MAC FREE PASSWORD#

MySQL on OS X doesnвЂ™t like the value вЂњlocalhostвЂќ. With all the above in place, youвЂ™re good to use MySQL on your Mac the usual way.

#DOWNLOAD MYSQL FOR MAC FREE FULL#

The following command will only work if the above has been added to the PATH variable, this wonвЂ™t work with aliases: mysql_secure_installationДЄlternatively, you can call the script with the full path: /usr/local/mysql/bin/mysql_secure_installation I highly recommend you run it before using MySQL, especially when youвЂ™re deploying on production servers. It lets you set a root user password, (dis-)allow remote access and remove test databases and users. MySQL comes with a handy script that will secure your installation. If you see a вЂњcommand not foundвЂќ error instead, something didnвЂ™t work out with the alias or PATH tweak. Try typing mysqladmin now and see what happens. bash_profile file will automatically be deleted for your convenience as soon as the PATH is updated. Open a new session and your PATH will now be amended with the MySQL location. Save and quit vi, then close the Terminal session. Now add the following line to it: export PATH='/usr/local/mysql/bin:$PATH'

#DOWNLOAD MYSQL FOR MAC FREE HOW TO#

HereвЂ™s how to tweak that PATH variable instead for a permanent solution:Д¬reate a new file in your home directory and call it.

This will work fine until you quit Terminal and start a new session. HereвЂ™s how to setup an alias: alias mysql=/usr/local/mysql/bin/mysqlДЄlias mysqladmin=/usr/local/mysql/bin/mysqladmin Or better yet, add this location to the PATH variable. To make it easier we can add a temporary alias to our shell. 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.

#DOWNLOAD MYSQL FOR MAC FREE PASSWORD#

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.

#DOWNLOAD MYSQL FOR MAC FREE ARCHIVE#

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 ( ).

#DOWNLOAD MYSQL FOR MAC FREE INSTALL#

There are several ways to install MySQL on your Mac, for example:

Download mysql for mac free