Local Client Configuration
This article provides instructions on how to configure a local database client for use with DBeaver.
A local client refers to the database client software installed on your machine, allowing DBeaver to interact with your databases. This local installation is necessary for specific features like native backup and restore operations.
Key points to consider:
- In the Community Edition of DBeaver on Windows, local clients are downloaded from the internet when a remote client is selected in the Local Client options, typically during the first usage of database-specific tools such as backup, or restore functions.
- Windows users with the Enterprise, Ultimate, or Team editions enjoy a simplified process, as many local clients come pre-included with the software.
- Mac and Linux users may need to perform additional steps to configure the local client. The exact procedure will vary depending on the system setup.
Upon initial configuration, DBeaver will attempt to automatically identify the paths to local database clients in the Windows environment. If this process is unsuccessful, manual path configuration may be necessary.
On macOS, DBeaver actively tries to find local database tools automatically, covering a range of installations without requiring specific configurations from the user.
Tips:
- For PostgreSQL on macOS: Installing the
libpq
package may help DBeaver automatically detect the client. Usebrew install libpq
in your terminal.- For MySQL Users on macOS: To facilitate automatic client detection by DBeaver, consider adding the
mysql-client
package. This can be done using the commandbrew install mysql-client
in the terminal.
If you encounter any issues with automatic detection, or if you're on a Linux system, follow the subsequent manual configuration steps below.
To find the installation path for the local client of a database in DBeaver, follow these general guidelines:
-
For MySQL: Use
mysqldump
as a keyword in your search command. This utility is often located in thebin
directory of the MySQL installation. -
For PostgreSQL: Substitute
mysqldump
withpg_dump
when conducting your search. Like MySQL, this command should be in thebin
directory of the PostgreSQL installation path.
These instructions are applicable to the most commonly used databases, MySQL and PostgreSQL.
-
Open your terminal.
-
Use the
find
command to locate the MySQL installation:find / -name "mysqldump" 2>/dev/null
-
Upon successful execution, the terminal will output the path to your MySQL installation. For example: -
/usr/local/mysql-8.1.0-macos13-arm64/bin/mysqldump
-
Copy this path for use in the next steps of the configuration process.
-
Open DBeaver.
-
Right-click on the respective database and navigate to Edit Connection Settings.
-
Find the Local Client section and click on the Browse button that appears next to it.
-
Click the Add Home button to add a new client path.
-
For Mac users, press Command+Shift+G to open the prompt for path input. For Linux users, enter the path directly into the file selection dialog.
-
Input the MySQL path location found earlier and confirm. Make sure to input the path up to the database version folder, omitting
/bin/mysql
.For example, if the path found is
/usr/local/mysql-8.1.0-macos13-arm64/bin/mysqldump
, input/usr/local/mysql-8.1.0-macos13-arm64/
. -
After inputting the corrected path, click the Open button to select the path.
-
Click the OK button to finalize the local client configuration.
- Installation
- Application Window Overview
- Views
- Database Object Editor
- SQL Editor
- Search
- Schema compare
- Using Liquibase in DBeaver
- Data compare
- MockData generation
- Spelling
- Dashboards, DB monitoring
- Projects
- Managing Master password
- Security in PRO products
- Certificate Management
- Bookmarks
- Shortcuts
- Accessibility
- 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