mysql

MySQL 8.0 Source Code Improvements With this post, I want to bring your attention to source code improvements in MySQL 8.0. MySQL 8.0 modernizes the code base by using C++11 constructs, being warning-free on more compilers and platforms, being UBSan- and ASan- clean, improving header file dependencies, improving the coding style, and better developer documentation.… Source: MySQL 8.0 Source Code Improvements

Password reuse policy in MySQL 8.0 MySQL has various kinds of password policy enforcement tools: a password can expire (even automatically), can be forced to be of a certain length, contain amounts of various types of characters and be checked against a dictionary of common passwords or the user account name itself.… Source: Password reuse policy in MySQL 8.0

New Defaults in MySQL 8.0 MySQL 8.0 comes with improved defaults, aiming at the best out of the box experience possible. Here we describe the changes and why they are made. Introduction Generally speaking, a good default is “the best choice for most users, most of the time”.… Source: New Defaults in MySQL 8.0

MySQL Shell 8.0.4: Introducing “Upgrade checker” utility MySQL 8.0 brings a lot of exciting new features and improvements. To make sure that your 5.7 system is ready for an upgrade there are certain steps you should take, described in our documentation: upgrade prerequisites. To make this process as quick and easy as possible we are introducing in MySQL Shell version 8.0.4 new utility called “Upgrade checker” (UC).… Source: MySQL Shell 8.0.4: Introducing “Upgrade checker” utility

MySQL 8.0.4 : New Default Authentication Plugin : caching_sha2_password Starting with MySQL 8.0.4, we are changing the default authentication plugin for MySQL server from mysql_native_password to caching_sha2_password. Correspondingly, libmysqlclient will now use caching_sha2_password as the default authentication mechanism, too. Why did we do it? The advantage of mysql_native_password is that it support challenge-response mechanism which is very quick and does not require encrypted connection.… Source: MySQL 8.0.4 : New Default Authentication Plugin : caching_sha2_password