ERROR1054(42S22):Unknowncolumn'password'in'fieldlist'問題的解決辦法

mysql>usemysql;

Databasechanged

mysql>updateusersetpassword=password('123456')whereuser='root';

ERROR1054(42S22):Unknowncolumn'password'in'fieldlist'

mysql>

改成這樣:updateusersetauthentication_string=password('123456')whereuser='root';

QueryOK,1rowaffected,1warning(0.01sec)

Rowsmatched:1Changed:1Warnings:1

發佈留言