下面这个语句哪里出错了

update user set authentication_string = password ( '123456' ) where user = 'root' ;

update user set authentication_string = '123456' where user = 'root' ;
password()是干啥的
user表中有个user字段？

UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';