You are viewing the documentation of an older version of the TiDB database (TiDB v3.0).

It is recommended that you use the latest LTS version of the TiDB database.

Security Compatibility with MySQL

TiDB supports similar security functionality to MySQL 5.7, with the following exceptions:

  • Only the mysql_native_password authentication scheme is supported
    • In MySQL 8.0, mysql_native_password is no longer the default/preferred plugin. To connect to TiDB using a MySQL client from MySQL 8.0, you must explicitly specify default-auth=mysql_native_password.
  • External authentication (such as with LDAP) is not currently supported
  • Column level permissions are not supported
  • Password expiry, as well as password last-changed tracking and password lifetime are not supported #9709
  • The permission attributes max_questions, max_updated, max_connections, max_user_connections are not supported
  • Password validation is not currently supported #9741
  • Transparent Data Encryption (TDE) is not currently supported
Was this page helpful?