maria-discuss team mailing list archive

[Oliver <ofabelo@xxxxxxxxx>]

Thank you very much for responses. I've fixed it passing --port 3306
parameter in the connection command line. I thought that being default
port, it wasn't necessary.

Cheers...

El jue, 10 mar 2022 a las 16:51, Rajashekar Yeddulapalli (<
shekar.cloud.dba@xxxxxxxxx>) escribió:

> 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@xxxxxxxxx>
> 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@xxxxxxxxx>
>> *Sent: *Thursday, March 10, 2022 2:43 PM
>> *To: *maria-discuss@xxxxxxxxxxxxxxxxxxx
>> *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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>