Essential MySQL Features
Read this article on MySQL features you need to know. Pay attention and list the reasons that explain why MySQL is important. How does MySQL provide high performance and data security?
Dual passwords
Imagine corporate security reminds you to update the password on your 'application' (and by application, we mean eight hundred separate pieces of code that need to be edited to remove the old password and implement the new password). Even the most ardent Emacs fan would swallow hard and balk at trying this all at one time. To the rescue! MySQL 8.0 has support for dual passwords - one current password and a secondary password - to provide an easy way for you to transition to the new password.
ALTER USER 'appuser1' @ 'host1.example.com'
IDENTIFIED BY 'password_b'
RETAIN CURRENT PASSWORD;
Now you can change the password at a less frenetic pace and, when you have all the code updates, you simply remove the older password.
ALTER USER 'appuser1' @ 'host1.example.com'
DISCARD OLD PASSWORD;
You can also have the MySQL Server generate a random password for your account and set a threshold on the number of bad logins before automatically locking that account for a settable time limit.