Homebrew 설치

MySQL 설치

brew install mysql

설치가 완료되면 다음과 같은 메시지가 나옴

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

MySQL 서버 실행

brew services start mysql

또는 수동으로 실행하려면:

mysql.server start

MySQL 접속

mysql -u root

• 설치 직후에는 root 계정에 비밀번호가 설정되어 있지 않아서 그냥 접속됨

MySQL 서버 설정

mysql -u root
mysql_secure_installation

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?