Require Multiple Authentication Plugins Concurrently - MFA

Ability to require multiple authentication steps concurrently for specific users, the compliment of the new OR logic, for example, forcing a user to log in with both Unix Socket and mysql_native_password together to be able to start a session:

CREATE USER root@localhost IDENTIFIED VIA unix_socket AND mysql_native_password;