Grant Tables • HOST ,  USER : The account or role to which the default role applies. • DEFAULT_ROLE_HOST ,  DEFAULT_ROLE_USER : The default role. • FROM_HOST ,  FROM_USER : The account that is granted a role. • TO_HOST ,  TO_USER : The role that is granted to the account. • WITH_ADMIN_OPTION : Whether the account can grant the role to and revoke it from other accounts by using  WITH ADMIN OPTION . • Host ,  User : The account for which the password change occurred. • Password_timestamp : The time when the password change occurred. • Password : The new password hash value. The role_edges Grant Table The password_history Grant Table The  role_edges  table lists edges for role subgraphs. It has these columns: The  password_history  table contains information about password changes. It has these columns: The  password_history  table accumulates a sufficient number of nonempty passwords per account to enable MySQL to perform checks against both the account password history length and reuse interval. Automatic pruning of entries that are outside both limits occurs when password-change attempts occur. The empty password does not count in the password history and is subject to reuse at any time. If an account is renamed, its entries are renamed to match. If an account is dropped or its authentication plugin is changed, its entries are removed. Scope columns in the grant tables contain strings. The default value for each is the empty string. The following table shows the number of characters permitted in each column. Note Grant Table Scope Column Properties Table 6.8 Grant Table Scope Column Lengths Host  and  Proxied_host  values are converted to lowercase before being stored in the grant tables. Column Name Maximum Permitted Characters Host ,  Proxied_host 255 (60 prior to MySQL 8.0.17) User ,  Proxied_user 32 Db 64 Table_name 64 Column_name 64 Routine_name 64 1212