Users can be created using any plugin but can not be updated as such.
A user can be created and updated with any plugin. For example, create a user using sha256_password and be able to update the users password with the same plugin.
New users will be created with the plugin column set to the plugin value provided by the mysql_user type. On update, the plugin is hardcoded to be only mysql_native_password.