remote mysql access on a different port?

3 posts / 0 new
Topic locked
Last post
#1 Tue, 04/07/2015 - 09:20
sifuhall

remote mysql access on a different port?

I'm trying to allow remote access to a single mysql database on a different port.

I have added the user and granted all privileges from % to the specific database.

I've added the external bind address and commented out skip-networking from /etc/my.cnf

I've flushed privileges on mysql (technicall mariadb)

And I've setup the port forwarding in firewalld using

firewall-cmd --permanent --zone=external --add-masquerade
  349  firewall-cmd --permanent --zone=external --add-forward-port=port=3306:proto=tcp:toport=53306

I'm testing using dbforge studio but I'm still not able to connect remotely

What am I missing?

Tue, 04/07/2015 - 16:40
andreychek

Howdy,

What error do you receive when trying to connect to your database remotely?

Also, it looks like your port is "53306" ... what output do you receive if you run this command:

netstat -an | grep :53306

Tue, 04/07/2015 - 16:50
sifuhall

Thanks for the reply.

I don't have netstat but I do have ss and with that I get:

[root@vweb boss]# ss -an | grep :3306
tcp    LISTEN     0      50        64.191.139.180:3306                  *:*
[root@vweb boss]# ss -an | grep :53306
[root@vweb boss]#

so clearly isn't listening.

But I'm not sure where to go next?

Topic locked