Unknown column 'password' in 'field list' mysql

Question

1)I did log in with mysql -u root -p

2)use mysql

3)describe user -->

And it shows that I have a field "Password"

I updated the authentication_string before with : UPDATE mysql.user SET authentication_string= '1234' WHERE User = 'root';

Also used : update user set authentication_string=password('1234') where user='root';

This is the error : Error: Unknown column 'password' in 'field list'

It's very weird :D .Should I change the password again ?

Thank you for the answer!

Bill_Karwin_20860 · Answer

Note This function is deprecated in MySQL 5.7 and is removed in MySQL 8.0.

To change a user's password, do not manipulate the mysql.user table directly.

To change a password, use ALTER USER:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'auth_string';

See documentation for more examples and explanation.