Set the port to a port you know is open and not in use. Once you have opened the file using an editor, go to the bottom of the file and add the following configuration: You may need to append sudo to the command if you require higher security privileges. Once you have located the file, open it with your preferred editor. In some cases, the my.cnf file can actually be a ini file, like so: On a Windows machine, the MySQL configuration file can be in either the Windows directory or the root of the C drive. On macOS and Linux, you can find the MySQL configuration file in either the users home directory or within the /etc directory. Location of MySQL my.cnf file on MacOS or Linux This MYSQL configuration file can reside in different locations, depending on your system and how it was installed.īelow are some locations where your installation’s my.conf could be for different operating systems. The my.cnf file is the configuration file used by MySQL. Solution – Fixing communication link failure in DBeaverįirst, you will need to locate your my.cnf file. DBEAVER MYSQL CONNECTION DRIVERSThis post also assumes you already have the correct database drivers installed and have created the MySQL connection. Where possible I have provided alternative methods for both macOS and Windows. In the solution below I used a Linux machine running Ubuntu 20.04 and verified using a Windows machine running Ubuntu 18.04 through WSL2 (Windows Subsystem for Linux). To fix the communication link failure in DBeaver, we need to assign a port to MySQL. This error occurs when the port used by MySQL is busy. The problem isn’t with DBeaver, in fact, if you installed another MySQL GUI tool, this issue would still occur. Are you having trouble connecting to a local MySQL database through DBeaver Community Edition? DBeaver fails to connect to a local MySQL database with the error “ Communication link failure the last packet sent successfully to the server was 0 milliseconds ago“.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |