local

방법 1

https://soungnote.tistory.com/15

ps -ef | grep mysql
kill -15 PID # 실행중이 프로세스 종료
ls -laF /usr/local/var/mysql
sudo chown -R mysql /usr/local/var/mysql
mysql.server start

방법 2

https://stackoverflow.com/questions/9624774/after-mysql-install-via-brew-i-get-the-error-the-server-quit-without-updating/36156848

brew remove mysql
brew cleanup
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
rm -rf ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

sudo rm -rf /usr/local/var/mysql
mysql install mysql
mysqld --initialize --explicit_defaults_for_timestamp
mysql.server start

와.. 진짜 갑자기 local 에서 mysql 안되서 삽질 함 ㅠㅠㅠ 하 ..

password 변경

mysql -u root -p
enter password : 

mysql > use mysql;

mysql > alter user 'root'@'localhost' identified with mysql_native_password by '12345';

mysql > flush privileges;
mysql > quit