mysql 5.7 install for mac

mysql 5.7 install

• install

brew install mysql@5.7

• path を通す

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile

• シェル再起動してpath確認

source ~/.bash_profile

• version

mysql --version

• 起動と接続

brew services start mysql@5.7

mysql -u root

• すぐにユーザを作り権限付与

create user matsu@localhost identified by '1234';
create database nobu
grant create on *.* to matsu@localhost;