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:
-
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.
-
Views
-
Search
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation