MySQL user DB does not have password columns - Installing MySQL
- Install MySql-5.7.6 ~ .dmg(Community Server) and workbench.
- Turn off the server on OSX System preferences.
- Access MySql with console. The command was
mysqld_safe --skip-grant - Execute
update user set password=password('1111') where user='root';and got an error message –>ERROR 1054 (42S22): Unknown column 'password' in 'field list'.
FYI, I did use mysql;. So I did select query on user table and found password column actually does not exist.
It is very weird. Is it possible that original user table does not have password column?
How can I change password, which does not exist?
UPDATE mysql.user SET authentication_string= 'password' WHERE User = 'root'; Because the field ‘Password’ was removed by mysql and replaced with authentication_string. Note: that the mysql function PASSWORD(‘password’) relies on MD5 algorithm which was cracked long ago using the birth day attack.
