remote mysql access on a different port?

Help! (Home for newbies)
1

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

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

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?