Features Deprecated in MySQL 8.0 Features Deprecated in MySQL 8.0 The following features are deprecated in MySQL 8.0 and may be removed in a future series. Where alternatives are shown, applications should be updated to use them. For applications that use features deprecated in MySQL 8.0 that have been removed in a higher MySQL series, statements may fail when replicated from a MySQL 8.0 source to a higher-series replica, or may have different effects on source and replica. To avoid such problems, applications that use features deprecated in 8.0 should be revised to avoid them and use alternatives when possible. •The  utf8mb3  character set is deprecated. Please use  utf8mb4  instead. •Because  caching_sha2_password  is the default authentication plugin in MySQL 8.0 and provides a superset of the capabilities of the  sha256_password  authentication plugin,  sha256_password  is deprecated; expect it to be removed in a future version of MySQL. MySQL accounts that authenticate using  sha256_password  should be migrated to use  caching_sha2_password  instead. •The  validate_password  plugin has been reimplemented to use the component infrastructure. The plugin form of  validate_password  is still available but is now deprecated; expect it to be removed in a future version of MySQL. MySQL installations that use the plugin should make the transition to using the component instead. See Section 6.4.3.3, “Transitioning to the Password Validation Component” . •The  ENGINE  clause for the  ALTER TABLESPACE  and  DROP TABLESPACE  statements is deprecated. •The  PAD_CHAR_TO_FULL_LENGTH  SQL mode is deprecated. • AUTO_INCREMENT  support is deprecated for columns of type  FLOAT  and  DOUBLE  (and any synonyms). Consider removing the  AUTO_INCREMENT  attribute from such columns, or convert them to an integer type. •The  UNSIGNED  attribute is deprecated for columns of type  FLOAT ,  DOUBLE , and  DECIMAL  (and any synonyms). Consider using a simple  CHECK  constraint instead for such columns. • FLOAT( M , D )  and  DOUBLE( M , D )  syntax to specify the number of digits for columns of type  FLOAT  and DOUBLE  (and any synonyms) is a nonstandard MySQL extension. This syntax is deprecated. •The  ZEROFILL  attribute is deprecated for numeric data types, as is the display width attribute for integer data types. Consider using an alternative means of producing the effect of these attributes. For example, applications could use the  LPAD()  function to zero-pad numbers up to the desired width, or they could store the formatted numbers in  CHAR  columns. •For string data types, the  BINARY  attribute is a nonstandard MySQL extension that is shorthand for specifying the binary ( _bin ) collation of the column character set (or of the table default character set 40 For additional information, see Grant Table Concurrency. The operations that are now performed as non-locking reads on MySQL grant tables include: • Non-locking reads on MySQL grant tables.   As of MySQL 8.0.22, to permit concurrent DML and DDL operations on MySQL grant tables, read operations that previously acquired row locks on MySQL grant tables are executed as non-locking reads. • SELECT  statements and other read-only statements that read data from grant tables through join lists and subqueries, including  SELECT ... FOR SHARE  statements, using any transaction isolation level. •DML operations that read data from grant tables (through join lists or subqueries) but do not modify them, using any transaction isolation level.