Resolved “Unknown column ‘password’ in ‘field list'”

I was trying to recover Mysql root password through mysql safe mode .  When i tried to update the Mysql “user” table with new password, using following

As you can see , it was throwing following error

This means , there is no column named “password” inside the user table. After a quick google search, I found that In MySQL 5.7, the password field in mysql.user table field was removed, now the field name is ‘authentication_string’

In mysql 5.7+, you can use following command to reset the mysql password for a user

Compared to MySQL 5.6, the changes are quite extensive in 5.7 . Please see the complete list of changes here

 

Leave a Reply

Your email address will not be published. Required fields are marked *