What Is New in MySQL 8.0
| Feature | Mysql 5.7 | Mysql 8.0 |
| Data Dictionary | Stored in metadata files and non-transactional tables | Transactional data dictionary that stores information about database objects. |
| Atomic Data Definition Statements (Atomic DDL) | ————- | Dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic transaction combined by an atomic DDL statement. |
| Security and Account management | 1. MyISAM (nontransactional) grant tables | 1. InnoDB (transactional) grant tables. |
| 2. Account-management statements (such as CREATE USER or DROP USER) for naming multiple users could succeed for some users and fail for others. | 2. Each statement is transactional and either succeeds for all named users or rolls back and no effect if any error occurs. | |
| 3. mysql_native_password plugin. | 3.caching_sha2_password authentication plugin is available. Like the sha256_password plugin. | |
| 4. Not supported. | 4. MySQL now supports roles, which are named collections of privileges. | |
| 5. Single password for each account. | 5. Accounts are now permitted to have dual passwords. | |
| Resource management | Not supported | 1. Creation and management of resource groups.
2. Threads can be assigned to particular groups running within the server so that threads execute according to the resources available to the group. |
| Character Set support | Default character set : latin1 | Default character set : utf8mb4 |
| Data Type support | Use of expressions as default values for the BLOB, TEXT, GEOMETRY, and JSON data types. | |
| Indexes Visibility | Supports only visible indexes. | Now supports invisible indexes. |
And many more features and enhancements.