Authentication MySQL Two factor

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

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

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

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

1) 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.

2) Input your Username and Password associated with your database.

3) Click the Test Connection button or attempt to connect to the database.

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

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