https://yoku0825.blogspot.jp/2015/03/mysql-576mysqluser.html
mysql> SELECT user, host, password FROM mysql.user; +--------+--------------+-------------------------------------------+ | user | host | password | +--------+--------------+-------------------------------------------+ | root | localhost | *2AF14BD74D8A4FDB580D3208C0092BE75EE95B75 | | root | dd51374b09e7 | *2AF14BD74D8A4FDB580D3208C0092BE75EE95B75 | | root | 127.0.0.1 | *2AF14BD74D8A4FDB580D3208C0092BE75EE95B75 | | root | ::1 | *2AF14BD74D8A4FDB580D3208C0092BE75EE95B75 | | fabric | % | *BA4015F6659FB2A40463B9728083556079C45EE7 | | app | % | *07C85F556938C8B845F807BCD7EA0B7A296072DC | +--------+--------------+-------------------------------------------+ 6 rows in set (0.11 sec)
バージョンアップでなくなった模様です。
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
"Theuser
tableplugin
,Password
, andauthentication_string
columns store authentication plugin and credential information. In MySQL 5.7.6, thePassword
column was removed and all credentials are stored in theauthentication_string
column. "
MySQL5.7が境目