Features Removed in MySQL 8.0 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” . •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. •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. 43 Additionally, because  IDENTIFIED BY PASSWORD  syntax was removed, the log_builtin_as_identified_by_password  system variable is superfluous and was removed. •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: Table 1.1 Renamed InnoDB Information Schema Views Old Name New Name INNODB_SYS_COLUMNS INNODB_COLUMNS INNODB_SYS_DATAFILES INNODB_DATAFILES INNODB_SYS_FIELDS INNODB_FIELDS INNODB_SYS_FOREIGN INNODB_FOREIGN INNODB_SYS_FOREIGN_COLS INNODB_FOREIGN_COLS INNODB_SYS_INDEXES INNODB_INDEXES INNODB_SYS_TABLES INNODB_TABLES INNODB_SYS_TABLESPACES INNODB_TABLESPACES INNODB_SYS_TABLESTATS INNODB_TABLESTATS INNODB_SYS_VIRTUAL INNODB_VIRTUAL After upgrading to MySQL 8.0.3 or later, update any scripts that reference previous  InnoDB INFORMATION_SCHEMA  view names.