报错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