sks147/mysql.md

## mysql.md

      
    Raw
  

              mysql.md
            
          
    To install, run:

$ brew update
$ brew install mysql
Usage

To have launchd start MySQL now and restart at login:

$ brew services start mysql
Or, if you don't want/need a background service you can just use the mysql.server tool:

$ mysql.server start
To stop it when you are done, run:

$ mysql.server stop
You can see the different commands available for mysql.server with:

$ mysql.server --help
To connect with the command-line client, run:

$ mysql -u root --skip-password
$ mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new-password';
To fix Client does not support authentication protocol

$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
$ flush privileges;