错误的原因是 5.7版本下的mysql数据库下已经没有password这个字段了,password字段改成了authentication_string
修改密码时需将
password
改成
authentication_string
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5iM2kjM5M2MyQGM5QTN0ITMzYzX5QjMwIDMzAzLclDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
解决方案
update mysql.user set authentication_string=password('12345678') where user='**';
mysql> flush privileges;
mysql -u root -p
> 输入密码 (12345678)