Note It is not permitted to use any internal credential storage plugins (caching_sha2_password or mysql_native_password) for factor 2 or 3. Suppose that you want an account to authenticate first using the caching_sha2_password plugin, then using the ... Authentication involves one party establishing its identity to the satisfaction of a second ...

Mark the password expired so that the user must choose a new one at the first connection to the server: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'new_password' PASSWORD EXPIRE; Example: Create an account that uses the caching_sha2_password ...

Suppose that you want an account to authenticate first using the caching_sha2_password plugin, then using the authentication_fido plugin. Create a multifactor account using a statement like this: CREATE USER 'u2'@'localhost' IDENTIFIED WITH ... Note ...