![]() MySQL now maintains information about password history, enabling restrictions on reuse of previous passwords.Roles can have privileges granted to and revoked from them, and they can be granted to and revoked from user accounts. MySQL now supports roles, which are named collections of privileges. ![]() It provides more secure password encryption than the mysql_native_password plugin, and provides better performance than sha256_password. It implements SHA-256 password hashing, but uses caching to address latency issues at connect time. The new caching_sha2_password authentication plugin is now the default authentication method in MySQL 8.0.The grant tables in the mysql system database are now InnoDB tables.MySQL 8.0 makes it possible to persist global, dynamic server variables using the SET PERSIST command instead of the usual SET GLOBAL one.Īs there are many improvements related to security and user management, we’ll list them in a separate section.Document Store for developing both SQL and NoSQL document applications using a single database.This index is not used by the optimizer and makes it possible to test the effect of removing an index on query performance, without removing it. This provides an alternative to the single administrative connection that is permitted on the network interfaces used for ordinary connections even when max_connections connections are already established. MySQL Server now permits a TCP/IP port to be configured specifically for administrative connections.The BACKUP_ADMIN privilege is required to use these statements. The new backup lock is supported by LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE syntax. A new type of backup lock permits DML during an online backup while preventing operations that could result in an inconsistent snapshot. ![]() Traditional error logging is implemented using built-in components, and logging using the system log is implemented as a loadable component.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |