mysql - reading initial communication packet - password hash should be a 41-digit hexadecimal number

现象:在苹果电脑上的xampp,访问phpmyadmin时提示错误,错误信息如:reading initial communication packet password hash should be a 41-digit hexadecimal number。

尝试:在my.cnf文件里添加 skip-grant-tables 后重启mysql,再登录到mysql,通过 UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = 'localhost' AND User = 'root'; 来重置root用户的密码。

参考:

标签: mysql

添加新评论