Mac 下登陆mysql报错:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before exec
ERROR 29 (HY000): File ‘./mysql/user.MYD’ not found (Errcode: 13 - Permission denied)
解决方法:
1.输入命令,设置权限: sudo chown -R mysql /usr/local/mysql/data/
2.登陆进入mysql
3.修改密码:
alter user user() identified by “qwedq123”;