homebrew离线安装mysql_[Homebrew]brew下安装mysql的一些常用配置

On macOS, you can install MySQL easily using Homebrew.

brew install mysql

You can now start the MySQL server by running:

brew services start mysql

brew services stop mysql

Now we need to secure the MySQL server. By default the server comes without a root password, so we need to make sure it’s protected.

mysql_secure_installation

You can also avoid this daemon mode (that’s what we call programs that always run in the background and restart when the computer is restarted) by running:

mysql.server start

mysql.server stop

Now you can connect to the server using the command:

mysql -u root -p

A great GUI (graphical) software we can use to interact with a SQLite database is TablePlus.