...
| Excerpt |
|---|
There are some differences in between Mac and Linux(CentOS) for my.cnf and some command line interfaces. There are two different approach to install MySQL on MAC: 1) Install by dmg file can download at https://www.mysql.com/downloads/ and 2) installing by brew. I will talk about the installation based on brew here. |
Install MySQL by brew
If you face any error when you run below command line, you will need to install brew.
| Code Block |
|---|
sudo brew install mysql |
...
If you want to allow connection from other external servers, you need to modify /usr/local/Cellar/mysql/8.0.19/homebrew.mxcl.mysql.plist and bind-address=0.0.0.0 as following:
...
Start MySQL
| Code Block |
|---|
sudo /usr/local/mysql/support-files/mysql.server startbrew services start mysql |
Stop MySQL
| Code Block |
|---|
sudo /usr/local/mysql/support-files/mysql.server stopbrew services stop mysql |
Restart MySQL
| Code Block |
|---|
sudo /usr/local/mysql/support-files/mysql.server restartbrew services restart mysql |
Set root access permission from all hosts
...