Note
This variable is available starting with V4.4.2 BP1.
Description
default_authentication_plugin specifies the default authentication plugin used for new users.
Privilege requirements
Query the variable
The
systenant and all user tenants can use theSHOW VARIABLESstatement, theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview in Oracle-compatible mode, or theinformation_schema.GLOBAL_VARIABLESview in MySQL-compatible mode to query the value of this Global system variable.Modify the variable
The
systenant can directly modify the value of this Global system variable.A MySQL user tenant must have the
SUPERorALTER SYSTEMprivilege to modify the value of this Global system variable.An Oracle user tenant must have the
ALTER SYSTEMprivilege to modify the value of this Global system variable.
Attributes
Attribute |
Description |
|---|---|
| Type | Varchar(64) |
| Default value | An empty string (''). Setting the variable to DEFAULT restores it to the empty string. |
| Value range |
|
| Scope | Global |
| Modifiable | Yes. You can use the SET statement to modify the value. |
Notice
caching_sha2_password is supported starting with V4.4.2 BP2.
Examples
Set the default authentication plugin for new users to caching_sha2_password:
obclient> SET default_authentication_plugin = 'caching_sha2_password';