Mysql with non-standard port number

I am trying to migrate from a “bare metal” installation of to mysql to one inside a kubernetes pod. The cluster makes the database accessible on port 32000 (rather than 3306).

When I change the configuration to point to port 32000 (and the new IP address of the K8 cluster), I get the following error message:

Access denied for user ‘weather’@‘192.168.1.70’ (using password: YES)
ERROR: MySQL server has gone away at time/date 1:15:43 AM 11/04/18

The error message does not make sense since I have granted all privileges to weather@%.

Could it be that the wdmysql executable is not properly handling connections to non standard/high ports?

Renato

Just finished installing on the same machine the mysql workbench.

Using it, I am successfully able to connect to the database on port 32000.

So i does appear that the culprit is indeed wdmysql.

Renato

Hi
it looks to me to be more of a permissions problem?
when you open the wdmysql program, do you see the port listed as what is needed?

Brian

Yes, I do. I see IP set to 192.168.1.50 (K8 node) and port set to 32000.

192.168.1.70 is the ip address of the desktop running WD 10.37S82.

Renato

are you able to set to use the default port instead?

unfortunately I am not. Since kubernetes creates a mapping between the internal network/port and the external one (i.e usually 10.x.x.x to 192.x.x.x)

Renato

so there is an external IP
are you able to port forward that and let me know so that I can do some testing here?