How to deal with the following MySQL error: "ERROR 1054 (42S22): Unknown column 'Password' in 'filed list'"?

Question

MySQL

Beginner bydlokoderast. I torture MySQL from under the Windows console. Installed by unpacking from the archive. I didn’t understand: either by default there is some kind of password, or at the very first start, without realizing it, I set some kind of password (deleting and re-unpacking is not treated). I go with the --skip-grant-tables option, try to set the password setting commands (SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');) or display a list of users (SELECT user,host,password FROM mysql. user;) - each time swears at the word password as follows ERROR 1054 (42S22): Unknown column 'Password' in 'filed list'. And the last command without password (in the form of SELECT user,host,password FROM mysql.user;) works fine and produces a list of two users: mysql.sys and root.
UPD
Forgot to say: MySQL is currently installed at 5.7.9, if that information is of any significance.

Answer 1

try like this

UPDATE `mysql`.`user` SET `Password` = PASSWORD('YOU PASSWORD') WHERE `user`.`Host` = 'localhost' AND `user`.`User` = 'root'

Answer 2

This means that the password field is not in the table

Answer 3

stackoverflow.com/questions/30692812/mysql-user-db...
maybe like me, there is no password field, but there is authentication_string
puts the password in 1111