a.空(即默认,等同于mysql_native_password)
b.mysql_native_password
因为dble的连接模型是预先建立后端连接池，所以前端连接设置的一些权能标志位无法生效，这里列举一下权能标志位的使用情况。
当后端连接的标志位使用了之后，无法通过前端连接设置来重置。
如：select @@sql_mode 会永远包含IGNORE_SPACE
| 名称 | 标记值 | 描述 | 后端连接设置值 | 模拟服务端权能位 |
|---|---|---|---|---|
CLIENT_LONG_PASSWORD |
1 |
Use the improved version of Old Password Authentication.Assumed to be set since 4.1.1. | Y |
Y |
CLIENT_FOUND_ROWS |
2 |
Send found rows instead of affected rows in EOF_Packet |
Y |
Y |
| CLIENT_LONG_FLAG | 4 | Get all column flags. | Y | Y |
CONNECT_WITH_DB |
8 |
Database (schema) name can be specified on connect in Handshake Response Packet. | Y |
Y |
| CLIENT_NO_SCHEMA | 16 | Don't allow database.table.column. | N | N |
CLIENT_COMPRESS |
32 |
Compression protocol supported |
server.xml的useCompression选项控制 |
|
| CLIENT_ODBC | 64 | Special handling of ODBC behavior.No special behavior since 3.22. | Y | Y |
CLIENT_LOCAL_FILES |
128 |
Can use LOAD DATA LOCAL. |
Y |
Y |
CLIENT_IGNORE_SPACE |
256 |
Ignore spaces before '('. |
Y |
Y |
CLIENT_PROTOCOL_41 |
512 |
New 4.1 protocol |
Y |
Y |
CLIENT_INTERACTIVE |
1024 |
This is an interactive client. | Y | Y |
| CLIENT_SSL | 2048 | Use SSL encryption for the session | N | N |
CLIENT_IGNORE_SIGPIPE |
4096 |
Client only flag.Not used. | Y | Y |
CLIENT_TRANSACTIONS |
8192 |
Client knows about transactions | Y | Y |
| CLIENT_RESERVED | 16384 | DEPRECATED:Old flag for 4.1 protocol. | N | N |
CLIENT_RESERVED2 |
32768 |
DEPRECATED:Old flag for 4.1 authentication. | Y | Y |
CLIENT_MULTI_STATEMENTS |
65536 |
Enable/disable multi-stmt support |
Y |
Y |
CLIENT_MULTI_RESULTS |
131072 |
Enable/disable multi-results |
Y |
Y |
| CLIENT_PS_MULTI_RESULTS | 262144 | Multi-results and OUT parameters in PS-protocol | N | N |
| CLIENT_PLUGIN_AUTH | 524288 | Client supports plugin authentication. | N | Y |
| CLIENT_CONNECT_ATTRS | 1048576 | Client supports connection attributes. | N | N |
| CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA | 2097152 | Enable authentication response packet to be larger than 255 bytes. | N | N |
| CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS | 4194304 | Don't close the connection for a user account with expired password. | N | N |
| CLIENT_SESSION_TRACK | 8388608 | Capable of handling server state change information. | N | N |
| CLIENT_DEPRECATE_EOF | 16777216 | Client no longer needs EOF_Packet and will use OK_Packet instead. | N | N |
| CLIENT_SSL_VERIFY_SERVER_CERT | 1UL << 30 | Verify server certificate | N | N |
| CLIENT_REMEMBER_OPTIONS | 1UL << 31 | Don't reset the options after an unsuccessful connect. | N | N |
权能标志位定义 :
参考 https://dev.mysql.com/doc/dev/mysql-server/8.0.1/group__group__cs__capabilities__flags.html