Features Removed in MySQL 8.0 This change does not affect text file import or export operations performed with  LOAD DATA  or SELECT ... INTO OUTFILE , for which  NULL  continues to be represented by  \N . See Section 13.2.7, “LOAD DATA Statement” . For the C API,  MYSQL_OPT_SSL_ENFORCE  and  MYSQL_OPT_SSL_VERIFY_SERVER_CERT  options for  mysql_options()  correspond to the client-side  --ssl  and  --ssl-verify-server-cert options and are removed. Use  MYSQL_OPT_SSL_MODE  with an option value of  SSL_MODE_REQUIRED  or SSL_MODE_VERIFY_IDENTITY  instead. Upgrades are supported only from one major version to another (for example, 5.0 to 5.1, or 5.1 to 5.5), so there should be little remaining need for conversion of older 5.0 database names to current versions of MySQL. As a workaround, upgrade a MySQL 5.0 installation to MySQL 5.1 before upgrading to a more recent release. Two MySQL storage engines currently provide native partitioning support:  InnoDB  and  NDB . Of these, only  InnoDB  is supported in MySQL 8.0. Any attempt to create partitioned tables in MySQL 8.0 using any other storage engine fails. Ramifications for upgrades.   The direct upgrade of a partitioned table using a storage engine other than  InnoDB  (such as  MyISAM ) from MySQL 5.7 (or earlier) to MySQL 8.0 is not supported. There are two options for handling such a table: •Remove the table’s partitioning, using  ALTER TABLE ... REMOVE PARTITIONING . •Change the storage engine used for the table to  InnoDB , with  ALTER TABLE ... ENGINE=INNODB . •The generic partitioning handler was removed from the MySQL server. In order to support partitioning of a given table, the storage engine used for the table must now provide its own (“native” ) partitioning handler. The  --partition  and  --skip-partition  options are removed from the MySQL Server, and partitioning-related entries are no longer shown in the output of  SHOW PLUGINS  or in the INFORMATION_SCHEMA.PLUGINS  table. •The  mysql_install_db  program has been removed from MySQL distributions. Data directory initialization should be performed by invoking  mysqld  with the  --initialize  or  --initialize- insecure  option instead. In addition, the  --bootstrap  option for  mysqld  that was used by mysql_install_db  was removed, and the  INSTALL_SCRIPTDIR CMake  option that controlled the installation location for  mysql_install_db  was removed. •The server no longer performs conversion of pre-MySQL 5.1 database names containing special characters to 5.1 format with the addition of a  #mysql50#  prefix. Because these conversions are no longer performed, the  --fix-db-names  and  --fix-table-names  options for  mysqlcheck , the  UPGRADE DATA DIRECTORY NAME  clause for the  ALTER DATABASE  statement, and the Com_alter_db_upgrade  status variable are removed. •The  ignore_builtin_innodb  system variable is removed. •The  --temp-pool  server option was removed. • PROCEDURE ANALYSE()  syntax is removed. •The parser no longer treats  \N  as a synonym for  NULL  in SQL statements. Use  NULL  instead. •The client-side  --ssl  and  --ssl-verify-server-cert  options have been removed. Use  --ssl- mode=REQUIRED  instead of  --ssl=1  or  --enable-ssl . Use  --ssl-mode=DISABLED  instead of  -- ssl=0 ,  --skip-ssl , or  --disable-ssl . Use  --ssl-mode=VERIFY_IDENTITY  instead of  --ssl- verify-server-cert  options. (The server-side  --ssl  option is still available, but is deprecated as of MySQL 8.0.26 and subject to removal in a future MySQL version.) 46