Skip to content

Authentication MySQL Two factor

Note: This feature is available in Lite, Enterprise, Ultimate and Team editions only.

Overview

In addition to Database Native authentication, DBeaver also provides an option for Two-Factor Authentication (2FA.md). This feature requires a secondary password, offering enhanced security for database connections.

Settings

To set up Two-Factor Authentication with a secondary password, please refer to the official MySQL documentation: Multi-Factor Authentication.

How to Use

When Two-Factor Authentication is enabled, you need to enter the secondary password along with your primary credentials:

  • In the Authentication dropdown menu, choose the Two-factor authentication method.

    Tip: If you check the Save credentials locally option, you will not be asked to input your credentials every time you connect.

  • Input your Username and Password associated with your database.

  • Click the Test Connection button or attempt to connect to the database.

  • A window for the Secondary Password will appear. Enter your secondary password.

  • If all details are correct, DBeaver will establish a connection using both your primary and secondary passwords.