MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’

This intention is to change a user’s password. The command found on the Internet is as follows


MySQL & gt; update user set password = password ("new password") where user = "user name";

Error 1054 (42s22) unknown column 'password' in 'field list'

The reason for the error is that there is no password field in MySQL database of version 5.7, and the password field is changed to authentication_ string

Read More: