[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...
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
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
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...
Dbeaver uses mysql client binaries for some of the operations but most of them are done using the jdbc drivers by the version you choose. You should choose mariadb and not mysql. Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: <mailto:ngtech1ltd@gmail.com> ngtech1ltd@gmail.com From: Maria-discuss <maria-discuss-bounces+ngtech1ltd=gmail.com@lists.launchpad.net> On Behalf Of Oliver Sent: Thursday, March 10, 2022 15:43 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...
participants (4)
-
Eliezer Croitoru -
Oliver -
Rajashekar Yeddulapalli -
Vladislav Vaintroub