Install mysql on Mac

Install mysql on Mac

这里使用 homebrew 安装。

安装命令：#

Copy
brew install mysql 

Copy
安装之后的命令，留一个备份。
Pruned 1 symbolic links and 2 directories from /usr/local
==> Caveats
==> openssl@1.1
A CA file has been bootstrapped using certificates from the system
keychain. To add additional certificates, place .pem files in
  /usr/local/etc/openssl@1.1/certs

and run
  /usr/local/opt/openssl@1.1/bin/c_rehash

openssl@1.1 is keg-only, which means it was not symlinked into /usr/local,
because macOS provides LibreSSL.

If you need to have openssl@1.1 first in your PATH run:
  echo 'export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"' >> ~/.zshrc

For compilers to find openssl@1.1 you may need to set:
  export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
  export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"

==> protobuf
Emacs Lisp files have been installed to:
  /usr/local/share/emacs/site-lisp/protobuf
==> mysql
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -uroot

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 run:
  mysql.server start

相关命令：#

Copy
启动：    mysql.server start
停止：    mysql.setver stop 
登录：    mysql -u root  ;  登录root用户。
选择一个database ：  use  erwa 
查看所有的database：  show databases 

Copy
查看这个命令是干什么的：
man mysql 

插入成功截图#

TOPS：#

1、更新homebrew的时候遇到了个小问题，卡了半天之后提示没有权限。

You should change the ownership of these directories to your user.

这里根据他的提示输入命令，然后提示输入当前用户的密码，给 赋予权限，然后重新执行OK。

2、登录的时候没找到默认的初始密码。 尝试了一下不输入密码后，确实登录成功了。