Install Mysql Workbench Mac Brew

There are many ways to install PHP, MySQL & Nginx on Mac. Here we will be doing it using brew.

  1. Install Mysql Workbench Mac Brew Free
  2. Install Mysql Workbench Mac Brewer
  3. Install Mysql Workbench Mac Brew Pro

Installing PHP 5.4 (with FPM) on Mac OS X

Mysqlsecureinstallation The procedure can take a while, but it gives a lot of power to make sure you get the best defaults out of the box: Since we used brew services start mysql to start MySQL, your Mac will re-start it at reboot. Hello friends, welcome to my new tutorial, and in this tutorial, we will learn How to install MySQL Workbench on Windows, Mac and Ubuntu operating system properly using simple and easy steps. Most of the time, whenever we try to install MySQL Workbench, We face a lot of problems and failures in the process of installing it correctly.

Search for available PHP formulas (formula’s in homebrews are equivalent to packages in aptitude)

It will return long list of php 5.2, 5.3, 5.4 packages. We need 5.4. Tap it using:

If you do not tap homebrew/dupes you will get Error: No available formula for zlib

Before we build PHP 5.4, you may like to exercise options using:

We have built it using:

After long wait, you can verify php & php-fpm version using php -v and php-fpm -v respectively.

Adding PHP-FPM to startup routine

Please check exact plist filename in /usr/local/Cellar/php54/

To Start PHP-FPM:

To Stop PHP-FPM

Installing MySQL on Mac OS X

Run following command:

In case you need mysql-workbench, please download it from here. It cannot be installed via brew.

Adding MySQL to startup routine

Please check exact plist filename in /usr/local/Cellar/mysql/

To Start

To Stop

Manual Start/Stop

Start mysql: /usr/local/mysql/support-files/mysql.server start

Stop mysql: /usr/local/mysql/support-files/mysql.server stop

See other options – /usr/local/mysql/support-files/mysql.server -h

Changes to MySQL Config (optional)

For security

Run following command to improve security of your mysql setup. It will present you wizard to set mysql root password among other things.
Install Mysql Workbench Mac Brew

For workbench

Following changes will make it easy to use MySQL WorkBench

Installing Nginx on Mac OS X

Run following command:

Install

Adding Nginx to startup routine

Please check exact plist filename in /usr/local/Cellar/mysql/

To Start

To Stop

Workbench

Changes to Nginx Config (optional)

By default, Nginx setup expects you to define all virtual hosts in /usr/local/etc/nginx/nginx.conf

Edit default config file and following line to http{..} block

Next you can create sites-available and sites-enabled folder to manage virtual hosts config.

Troubleshooting

Finding default location of config/error files for PHP, MySQL & Nginx

Install Mysql Workbench Mac Brew Free

I did not get any error but after getting used to Ubuntu-conventions, I struggled to find where are config/log files and other defaults are present.

3 commands below turned out to be life-saver:

  • brew list nginx
  • brew list php54
  • brew list mysql

Brew’s list command shows all files/folders created by a package. Once you see output, you will notice, why I was getting lost!

Install Mysql Workbench Mac Brewer

If you come across any other error, feel free to use our support forum. We will try to fix it there.

Install Mysql Workbench Mac Brew Pro

Next: Install WordPress