How can DBeaver connect to MySQL?
The method of connecting DBeaver to MySQL is as follows:
- Open the DBeaver application.
- In the connection manager, right-click on the “Database Connection” folder and choose “Create New Database Connection”.
- Select “MySQL” as the driver type in the pop-up dialog box.
- In the “Basic Information” tab, enter the connection name and the host name (IP address or host name of the MySQL server).
- Enter your username and password in the “Authentication” tab so that DBeaver can connect to the MySQL server.
- (Optional) If your MySQL server is using a non-default port for connection, please enter the correct port number in the “Advanced Settings” tab.
- Click the “Test Connection” button to ensure that DBeaver can successfully connect to the MySQL server.
- Click the “Finish” button to save the connection configuration.
- In the connection manager, locate the newly created MySQL connection and double click to open it.
- You can now use DBeaver to query and manage MySQL databases.