[Squirrel-sql-users] Cannot connect to mysql

[Martin R. <mro...@go...>]

Hi,

 

I am trying to connect to a mysql database from squirrel.

 

I installed squirrel sql client version 4.4.0 on a Windows 11 PC.

The mysql database (Maria DB 10) is running on a synology NAS System.

I retrieved the mysql-connector-java-8.0.30.jar and copied it into squirrel
lib folder .

Alias was set up with URL jdbc:mysql://DS220Plus:3306/clubman – instead of
hostname DS220Plus I also tried localhost and the exact IP address of my
Synology.

The rights for accessing the database (clubman) are setup within mysql for
the user account (that I used for connecting) as well as for the host with
all privileges.

I also tried with firewall deactivated.

Database is up and running and I am able to connect via phpMyAdmin.

But when I am trying to connect via squirrel I always get the message

„Unexpected Error occurred attempting to open an SQL connection.

class java.net.ConnectException: Connection refused: connect“

 

Here is the stack trace:

java.net.ConnectException: Connection refused: connect

            at java.base/java.net.PlainSocketImpl.waitForConnect(Native
Method)

            at
java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107)

            at
java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl
.java:399)

            at
java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSoc
ketImpl.java:242)

            at
java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.j
ava:224)

            at
java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)

            at java.base/java.net.Socket.connect(Socket.java:591)

            at
com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.ja
va:153)

            at
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnectio
n.java:63)

            at com.mysql.cj.NativeSession.connect(NativeSession.java:120)

            at
com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)

            at
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)

            at
com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)

            at
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)

            at
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198
)

            at
net.sourceforge.squirrel_sql.fw.sql.SQLConnector.getSqlConnection(SQLConnect
or.java:58)

            at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriver
Manager.java:110)

            at
net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConn
ectionCommand.executeConnect(OpenConnectionCommand.java:155)

            at
net.sourceforge.squirrel_sql.client.mainframe.action.openconnection.OpenConn
ectionCommand.lambda$execute$0(OpenConnectionCommand.java:89)

            at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java
:515)

            at
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

            at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecut
or.java:1128)

            at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecu
tor.java:628)

            at java.base/java.lang.Thread.run(Thread.java:834)

 

Maybe I did something wrong? Maybe the wrong driver?

 

Thanks for help.