Hi Oliver,

I had a similar issue but resolved it by correcting the port number in /etc/my.cnf file. If the file is empty, then add the port which you are trying to connect!

Sample:

shekar1432@Rajashekars-MBP etc % cat my.cnf

#

# This group is read both by the client and the server

# use it for options that affect everything

#

[client-server]

port=3306

#

# include *.cnf from the config directory

#

!includedir /opt/homebrew/etc/my.cnf.d

shekar1432@Rajashekars-MBP etc %

Thanks,

Rajashekar Y

On Thu, Mar 10, 2022 at 7:37 PM Vladislav Vaintroub vvaintroub@gmail.com wrote:

The error you are getting is WSAECONNREFUSED (you can find a lot of useful information googling just for 10061)

This means, there is no server on the machine/port you’re connecting to. You can try telnet to the machine and port, from the client machine, first. Get telnet to work, and spits out the server’s “welcome” network packet, then client won’t return 10061 either. Maybe you just need to open the firewall on that port.

PS. Dbeaver does not use MySQL client. It uses JDBC drivers.

*From: *Oliver ofabelo@gmail.com *Sent: *Thursday, March 10, 2022 2:43 PM *To: *maria-discuss@lists.launchpad.net *Subject: *[Maria-discuss] mysql 5.5 client vs mariadb 10 server

Hi,

I'm sorry for the question if it is clear that it isn't possible. I'm trying connect from a mysql 5.5.56 client against a mariadb 10 server and I'm having the next error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'server' (10061)

Subnet source is allowed in mariadb server and grant is given for 'root'@'source_server', it is allowed both IP and hostname. So not sure if it is config problem or compatibility problem. Someone knows please? Thanks beforehand.

P.D.: I can connect using dbeaver from my computer client using mysql binaries (but not sure what mysql client version uses dbeaver).

Cheers...

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

Dbeaver had two different drivers, one for old mysql and one for mariadb.

When you add a new connection you can choose the right jdbc driver from a list and a filter can help with that.

The test connection might help to identify the basic issue.

All The Bests,

Eliezer

----

Eliezer Croitoru

NgTech, Tech Support

Mobile: +972-5-28704261

Email: ngtech1ltd@gmail.com mailto:ngtech1ltd@gmail.com

From: Maria-discuss maria-discuss-bounces+ngtech1ltd=gmail.com@lists.launchpad.net On Behalf Of Vladislav Vaintroub Sent: Thursday, March 10, 2022 17:36 To: Oliver ofabelo@gmail.com; maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] mysql 5.5 client vs mariadb 10 server

The error you are getting is WSAECONNREFUSED (you can find a lot of useful information googling just for 10061)

This means, there is no server on the machine/port you’re connecting to. You can try telnet to the machine and port, from the client machine, first. Get telnet to work, and spits out the server’s “welcome” network packet, then client won’t return 10061 either. Maybe you just need to open the firewall on that port.

PS. Dbeaver does not use MySQL client. It uses JDBC drivers.

From: Oliver mailto:ofabelo@gmail.com Sent: Thursday, March 10, 2022 2:43 PM To: maria-discuss@lists.launchpad.net mailto:maria-discuss@lists.launchpad.net Subject: [Maria-discuss] mysql 5.5 client vs mariadb 10 server

Hi,

I'm sorry for the question if it is clear that it isn't possible. I'm trying connect from a mysql 5.5.56 client against a mariadb 10 server and I'm having the next error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'server' (10061)

Subnet source is allowed in mariadb server and grant is given for 'root'@'source_server', it is allowed both IP and hostname. So not sure if it is config problem or compatibility problem. Someone knows please? Thanks beforehand.

P.D.: I can connect using dbeaver from my computer client using mysql binaries (but not sure what mysql client version uses dbeaver).

Cheers...