Mac12.2下mysql各种蛋疼问题

报错Error: Could not link:
解决办法：rm -rf /usr/local/etc/bash_completion.d/brew
rm -rf /usr/local/share/zsh/site-functions/_brew
rm -rf /usr/local/share/man/man1/brew.1
rm -rf /usr/local/share/doc/homebrew

命令: mysqld --initialize-insecure
Please use --explicit_defaults_for_timestamp server option (see documentation for more details
报错：[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
 解决办法：更换数据库位置 my.cnf datadir=/usr/local/var/anotherData

 

报错：Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

解决办法：这个报错是数据库没有进行初始化导致，初始化又报错: 数据库中已经有文件存在。可能一开始安装多个版本，做了各种设置，因此最好的方式是备份重装

my.cnf 中 添加 skip-grant-tables  

取消密码登录，将数据备份出来 mysqldump -uroot -p yourdatabase > yourdatabase.sql 

彻底删除mysql的安装余留

kill掉mysql相关进程  ps -ef | grep mysql   kill pid 

brew list 查看已安装的mysql

brew uninstall mysql@5.7

brew uninstall mysql-connector-c

brew uninstall mysql-client

brew unlink mysql@5.7 --force   删除mysql相关链接 

brew cleanup     清除安装余留

删除mysql相关文件

sudo rm -rf /usr/local/mysql*;
sudo rm -rf /usr/local/var/mysql;
sudo rm -rf /usr/local/run/mysql*
sudo rm -rf /usr/local/opt/mysql*
sudo rm -rf /use/local/etc/my.cnf    /etc/my.cnf
sudo rm -rf /Library/StartupItems/My*
sudo rm -rf /Library/PreferencePanes/My*

sudo find / -name "*mysql.plist"   删除相关文件，排除掉/System下的文件

sudo rm -rf ~/Libaray/LaunchAgents/homebrew.mxcl.mysql.plist

sudo rm -rf /private/var/db/receipts/*mysql*

重启电脑  之前没有重启 删除之后又安装整整浪费了折腾了一个晚上

安装mysql

brew upgrade

brew list

brew install mysql@5.7

brew link mysql@5.7 --force     建立mysql系统变量

安装完成之后会提示你初始化mysql数据库 。不然报错：报错：Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

初始化mysql 配置密码

mysql_secure_installation

询问是否安装安全插件，，，根据个人需求安装 即密码强度要求 可以选择N 

mysql 输入密码 

启动mysql

brew services restart mysql@5.7 或mysql.server start 

brew services info mysql@5.7  查看状态

登录mysql mysql -uroot -pyourpassword