-
Searched both the wiki and open issues, but couldn't find a resolution to my issue. From the command line, I can ssh to my server and connect to my database without issue using '$ mysql -u admin -p'. This is a fresh MySQL install without any config changes. 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. In DBeaver, clicking on "Test tunnel configuration" results in success, but clicking on "Test connection" results in an error. See below for the error along with screenshots of my config. Note that I used the "MySQL 8+" driver. I tried using both JSch and SSHJ (as shows in screenshot below) with the same result. Would appreciate some guidance. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
Ugh...never mind...figured it out. I forgot to allow loopback connections. |
Beta Was this translation helpful? Give feedback.
Ugh...never mind...figured it out. I forgot to allow loopback connections.
Fixed by running:
sudo iptables -A INPUT -i lo -j ACCEPT
sudo iptables -A OUTPUT -o lo -j ACCEPT