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@gmail.com>) 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@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