Skip to content

Instantly share code, notes, and snippets.

@SagaieNet
Forked from nrollr/MySQL_macOS_Sierra.md
Created June 24, 2017 08:24
Show Gist options
  • Save SagaieNet/add59633bc23fa3690286044d2db8c77 to your computer and use it in GitHub Desktop.
Save SagaieNet/add59633bc23fa3690286044d2db8c77 to your computer and use it in GitHub Desktop.

Revisions

  1. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -1,7 +1,6 @@
    ## Install MySQL on macOS Sierra
    This procedure explains how to install [MySQL](https://www.mysql.com) using [Homebrew](http://brew.sh) on macOS Sierra 10.12

    ## Procedure
    ### Install Homebrew
    * Installing Homebrew is effortless, open Terminal and enter :
    `$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"`
  2. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    # Install MySQL on macOS Sierra
    ## Install MySQL on macOS Sierra
    This procedure explains how to install [MySQL](https://www.mysql.com) using [Homebrew](http://brew.sh) on macOS Sierra 10.12

    ## Procedure
  3. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,7 @@
    ## Install MySQL on macOS Sierra
    # Install MySQL on macOS Sierra
    This procedure explains how to install [MySQL](https://www.mysql.com) using [Homebrew](http://brew.sh) on macOS Sierra 10.12

    ## Procedure
    ### Install Homebrew
    * Installing Homebrew is effortless, open Terminal and enter :
    `$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"`
  4. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 3 additions and 5 deletions.
    8 changes: 3 additions & 5 deletions MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -6,8 +6,6 @@ This procedure explains how to install [MySQL](https://www.mysql.com) using [Hom
    `$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"`
    * **Note:** Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.



    ### Install MySQL
    At this time of writing, Homebrew has MySQL version **5.7.15** as default formulae in its main repository :

    @@ -17,8 +15,8 @@ At this time of writing, Homebrew has MySQL version **5.7.15** as default formul
    To install MySQL enter : `$ brew install mysql`


    #### Additional configuration
    To load and start the MySQL background service, open Terminal and execute the following commands :
    ## Additional configuration
    ### Homebrew

    * Install **brew services** first : `$ brew tap homebrew/services`
    * Load and start the MySQL service : `$ brew services start mysql`.
    @@ -30,7 +28,7 @@ Expected output : **Successfully started `mysql` (label: homebrew.mxcl.mysql)**
    Expected output : **Ver 14.14 Distrib 5.7.15, for osx10.12 (x86_64)**


    ###Configure MySQL
    ### MySQL
    Open Terminal and execute the following command to set the root password:
    `mysqladmin -u root password 'yourpassword'`

  5. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 4 additions and 4 deletions.
    8 changes: 4 additions & 4 deletions MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -21,13 +21,13 @@ To install MySQL enter : `$ brew install mysql`
    To load and start the MySQL background service, open Terminal and execute the following commands :

    * Install **brew services** first : `$ brew tap homebrew/services`
    * Load and start the MySQL service : `$ brew services start mysql`
    * Expected output : **Successfully started `mysql` (label: homebrew.mxcl.mysql)**
    * Load and start the MySQL service : `$ brew services start mysql`.
    Expected output : **Successfully started `mysql` (label: homebrew.mxcl.mysql)**

    * Check of the MySQL service has been loaded : `$ brew services list` <sup>[1](#1)</sup>

    * Verify the installed MySQL instance : `$ mysql -V`
    * Expected output : **Ver 14.14 Distrib 5.7.15, for osx10.12 (x86_64)**
    * Verify the installed MySQL instance : `$ mysql -V`.
    Expected output : **Ver 14.14 Distrib 5.7.15, for osx10.12 (x86_64)**


    ###Configure MySQL
  6. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -37,7 +37,9 @@ Open Terminal and execute the following command to set the root password:
    > **Important** : Use the single ‘quotes’ to surround the password and make sure to select a strong password!
    ###Database Management
    To manage your databases, I recommend using [Sequel Pro](http://www.sequelpro.com), a MySQL management tool designed for macOS. Current version available: **1.1.2**
    To manage your databases, I recommend using [Sequel Pro](http://www.sequelpro.com), a MySQL management tool designed for macOS.
    Current version available: **1.1.2**


    #####Comments
    <a name="1"><sup>1</sup></a> The `brew services start mysql` - instruction is equal to :
  7. @nrollr nrollr revised this gist Oct 8, 2016. 1 changed file with 5 additions and 3 deletions.
    8 changes: 5 additions & 3 deletions MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -40,7 +40,9 @@ Open Terminal and execute the following command to set the root password:
    To manage your databases, I recommend using [Sequel Pro](http://www.sequelpro.com), a MySQL management tool designed for macOS. Current version available: **1.1.2**

    #####Comments
    <a name="1"><sup>1</sup></a> The `brew services start mysql` - command is equal to :
    <a name="1"><sup>1</sup></a> The `brew services start mysql` - instruction is equal to :

    * `ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents`
    * and `launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist`
    ```
    $ ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
    $ launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
    ```
  8. @nrollr nrollr created this gist Oct 8, 2016.
    46 changes: 46 additions & 0 deletions MySQL_macOS_Sierra.md
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,46 @@
    ## Install MySQL on macOS Sierra
    This procedure explains how to install [MySQL](https://www.mysql.com) using [Homebrew](http://brew.sh) on macOS Sierra 10.12

    ### Install Homebrew
    * Installing Homebrew is effortless, open Terminal and enter :
    `$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"`
    * **Note:** Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.



    ### Install MySQL
    At this time of writing, Homebrew has MySQL version **5.7.15** as default formulae in its main repository :

    * Enter the following command : `$ brew info mysql`
    * Expected output: **mysql: stable 5.7.15 (bottled)**

    To install MySQL enter : `$ brew install mysql`


    #### Additional configuration
    To load and start the MySQL background service, open Terminal and execute the following commands :

    * Install **brew services** first : `$ brew tap homebrew/services`
    * Load and start the MySQL service : `$ brew services start mysql`
    * Expected output : **Successfully started `mysql` (label: homebrew.mxcl.mysql)**

    * Check of the MySQL service has been loaded : `$ brew services list` <sup>[1](#1)</sup>

    * Verify the installed MySQL instance : `$ mysql -V`
    * Expected output : **Ver 14.14 Distrib 5.7.15, for osx10.12 (x86_64)**


    ###Configure MySQL
    Open Terminal and execute the following command to set the root password:
    `mysqladmin -u root password 'yourpassword'`

    > **Important** : Use the single ‘quotes’ to surround the password and make sure to select a strong password!
    ###Database Management
    To manage your databases, I recommend using [Sequel Pro](http://www.sequelpro.com), a MySQL management tool designed for macOS. Current version available: **1.1.2**

    #####Comments
    <a name="1"><sup>1</sup></a> The `brew services start mysql` - command is equal to :

    * `ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents`
    * and `launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist`