content_image/689626.jpg
information_schema_stats_expiry  defines an expiration setting for cached INFORMATION_SCHEMA  table statistics. For more information, see Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries” . 

•Code related to obsoleted InnoDB  system tables was removed in MySQL 8.0.3. 

INFORMATION_SCHEMA  views based on InnoDB  system tables were replaced by internal system views on data dictionary tables. Affected InnoDB INFORMATION_SCHEMA  views were renamed: 

<img src='content_image/689626.jpg'>

After upgrading to MySQL 8.0.3 or later, update any scripts that reference previous InnoDB INFORMATION_SCHEMA  view names. 

•The following features related to account management are removed: 

•Using GRANT  to create users. Instead, use CREATE USER . Following this practice makes the NO_AUTO_CREATE_USER  SQL mode immaterial for GRANT  statements, so it too is removed, and an error now is written to the server log when the presence of this value for the sql_mode  option in the options file prevents mysqld  from starting. 

•Using GRANT  to modify account properties other than privilege assignments. This includes authentication, SSL, and resource-limit properties. Instead, establish such properties at account- creation time with CREATE USER  or modify them afterward with ALTER USER . 

• IDENTIFIED BY PASSWORD ’ auth_string ’  syntax for CREATE USER  and GRANT . Instead, use IDENTIFIED WITH auth_plugin  AS ’ auth_string ’  for CREATE USER  and ALTER USER , where the ’ auth_string ’  value is in a format compatible with the named plugin. 

Additionally, because IDENTIFIED BY PASSWORD  syntax was removed, the log_builtin_as_identified_by_password  system variable is superfluous and was removed. 

•The PASSWORD()  function. Additionally, PASSWORD()  removal means that SET PASSWORD ... = PASSWORD(’ auth_string ’)  syntax is no longer available. 

•The old_passwords  system variable. 

•The query cache was removed. Removal includes these items: 

•The FLUSH QUERY CACHE  and RESET QUERY CACHE  statements. 

