mac 下mysql重装
brew remove mysql
brew cleanup --force
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
sudo rm -rf /usr/local/var/mysql
brew install mysql
mysqld --initialize --explicit_defaults_for_timestamp
mysql.server start # no sudo!
参考blog:https://blog.csdn.net/pureszgd/article/details/81737237
这时可能只能使用具体指向启动
/usr/local/bin/mysql -uroot -p
查看一下,这也是个link
ls -lah /usr/local/bin/mysql
lrwxr-xr-x 1 seal admin 32B 1 18 11:18 /usr/local/bin/mysql -> ../Cellar/mysql/8.0.13/bin/mysql
配置bash
vim ~/.bash_profile
export PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
export MYSQLPATH=/usr/local/bin/mysql
export PATH=$PATH:MYSQLPATH
同步
source ~/.bash_profile
运行查看状态
mysql.server status
显示:SUCCESS! MySQL running (92806)
启动与停止
mysql.server start
mysql.server stop
记个 mysql下载地址
使用sqlpro登录报错
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/pl...
处理:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
flush privileges; #/刷新权限
再重置下密码:alter user 'root'@'localhost' identified by 'xxx';