mac下mysql重装笔记

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下载地址

https://dev.mysql.com/

---

使用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';