Mac的mysql安装和容易出现的问题
安装
1.安装mysql
笔者用的homebrew 不熟悉的小伙伴请自行安装
brew install mysql
2.登录&修改密码
mysql -uroot //登录
set password for 'root'@'localhost'='{你的密码}';
问题及解决
报错
ERROR 1290 (HY000) ....
ERROR 2002 (HY000)...
解决:
flush privileges//刷新权限
报错:
Column count of mysql.useris wrong. Expected 43, found 42. Created with MySQL 50552, nowrunning 50636. Please use mysql_upgrade to fix thiserror.
解决:
mysql_upgrade -u root -p(升级)