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