#HOW TO START MYSQL ON MAC HOW TO#
#HOW TO START MYSQL ON MAC INSTALL#
#HOW TO START MYSQL ON MAC ARCHIVE#
#HOW TO START MYSQL ON MAC FULL#
#HOW TO START MYSQL ON MAC PRO#

Rather than creating users and databases from the command line (which of course works fine), Sequel Pro will be of great help to you. ItРІР‚в„ўs also open source and itРІР‚в„ўs simply phenomenal: it allows you to administer local and remote databases and user accounts, and itРІР‚в„ўs a native OS X app. If youРІР‚в„ўre looking for a graphical admin tool, thereРІР‚в„ўs a SUPERB tool available for your Mac that exclusively deals with administering MySQL databases and users: itРІР‚в„ўs called Sequel Pro. WordPress for example wonРІР‚в„ўt connect when you use localhost as your DB_HOST value. 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.

#HOW TO START MYSQL ON MAC 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'

#HOW TO START MYSQL ON MAC 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. 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.

#HOW TO START MYSQL ON MAC 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 ( ).

#HOW TO START MYSQL ON MAC INSTALL#

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

How to start mysql on mac