You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In mysql 5.7.6 and onwards, the mysql.user table does not have a password column anymore. It's a authentication_string:
kitchen@5af1356b9fdf:~$ mysql -uroot -piloverandompasswordsbutthiswilldo mysql -s -e 'select user,host,password from mysql.user ;'
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'field list'
kitchen@5af1356b9fdf:~$ mysql -uroot -piloverandompasswordsbutthiswilldo mysql -s -e 'select user,host,authentication_string from mysql.user ;'
user host authentication_string
root localhost *0B99593EA05A61BB7D37562CA767CB36FE954CE8
This is actually somewhat more complicated since MariaDB continues to use the password-column by default. But if one is using pam-authentication the authentication_string column will be used.
In mysql 5.7.6 and onwards, the
mysql.user
table does not have apassword
column anymore. It's aauthentication_string
:See: https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The text was updated successfully, but these errors were encountered: