gembin · April 16, 2020 19:08 · Apr 16, 2020 · Apr 16, 2020
diff --git a/install_mysql_on_mac.md b/install_mysql_on_mac.md
@@ -10,6 +10,7 @@ If you run into this error using GUI tools, e.g. **Sequel Pro**:
 Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
 ```
 Then do the following steps:
+
 `vi /usr/local/etc/my.cnf` in section `[mysqld]` add line:
 ```
 default-authentication-plugin=mysql_native_password

diff --git a/install_mysql_on_mac.md b/install_mysql_on_mac.md
@@ -0,0 +1,30 @@
+### Install
+```bash
+brew install mysql
+brew tap homebrew/services
+brew services start mysql
+```
+### Configuration
+If you run into this error using GUI tools, e.g. **Sequel Pro**:
+```
+Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
+```
+Then do the following steps:
+`vi /usr/local/etc/my.cnf` in section `[mysqld]` add line:
+```
+default-authentication-plugin=mysql_native_password
+```
+Login to mysql with `mysql -u root -p`:
+```SQL
+ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
+```
+And then restart:
+```bash
+brew services restart mysql
+```
+
+### Stop
+```bash
+brew services stop mysql
+```
+