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用户的密码。
参考: