IPTables is as follows: # iptables -L -v -nĬhain INPUT (policy DROP 328 packets, 18119 bytes) MySQL bind-address is the default: # grep -Irs bind /etc/mysql I also tried changing the user's plugin from caching_sha2_password to mysql_native_password, with the same result. I also tried connecting using 127.0.0.1 instead of localhost, with the same result. What can I do to fix that Note: DBeaver works fine with other databases. I tried with Database: testdb, but I get the same error. I am getting 'connection timed out' error. Here is the screenshot of the settings I used. I also tried using both JSch and SSHJ with the same result. DB name - testdb Master username - admin Now I am trying to connect to that database using DBeaver. Note that I tried using the " MySQL 8+ driver" as well as the " MySQL driver". See below for the error along with screenshots of my config. In DBeaver, clicking on " Test tunnel configuration" results in success, so SSH tunnel is fine.īut clicking on " Test connection" results in an error. | admin | caching_sha2_password | localhost | SELECT user,plugin,host FROM er WHERE user='admin' GRANT ALL PRIVILEGES ON *.* TO PRIVILEGES CREATE DATABASE main ĬREATE USER IDENTIFIED BY 'XXX_PASSWORD_REDACTED_XXX' The only thing I did was create a dummy database ("main") and a new database user ("admin") and grant the user access to the database. This is a fresh MySQL install without any config changes. usr/sbin/mysqld Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))įrom Windows command line, I can ssh to my server and connect to my database without issue: FROM WINDOWS COMMAND LINE: MySQL version information: # mysql -version Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. The driver has not received any packets from the server.Ĭan not read response from server. The last packet sent successfully to the server was 0 milliseconds ago. The error message is: Communications link failure I also tried other Windows MySQL GUI clients, with the identical results, which leads me to believe the problem is with MySQL configuration (or maybe with my local Java installation?). DBeaver 7.1.0 on Windows 10 trying to connect to MySQL 8.0.20 on Ubuntu 20.04 using SSH.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |