本文共 822 字,大约阅读时间需要 2 分钟。
且5.7之后移除了password,它采用了新的算法
mysql> select user,host,password from mysql.user;ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql> select user,host,authentication_string from mysql.user;+------+-----------+-------------------------------------------+| user | host | authentication_string |+------+-----------+-------------------------------------------+| root | localhost | *8A7993B6A9F0539BBE570DB3FD66FC580093FB05 || root | % | *8A7993B6A9F0539BBE570DB3FD66FC580093FB05 |+------+-----------+-------------------------------------------+2 rows in set (0.00 sec)
PASSWORD(str)This function was removed in MySQL 8.0.11.
转载地址:http://yoorb.baihongyu.com/