Unknown column ‘Password‘ in ‘field list‘

Using statements in MySQL

update user set password=password(“xxxxx”) where user=“root”;

Times error

Solution:
since there is no password segment after mysql5.7, it should be changed to

update user set authentication_ string=password(“xxxxx”) where user=“root”;

It can be solved


Read More: