This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

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?

#2 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

#3 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