topic Re: How to open up port 3306 in Plusnet Hub 2 in My Router

How to open up port 3306 in Plusnet Hub 2

PaulFreeland — Tue, 06 Jun 2023 11:35:16 GMT

Hello

I have just had full fibre installed and it's working well, except I now need to access remote MySQL databases directly, using port 3306, and it is blocked.

The database client software is returning:

Access denied for user 'root'@' [Removed].plus.com' (using password: YES)

[Removed].plus.com is not the server I am trying to connect to. I assume this is a Plusnet firewall blocking the connection.

Moderators Note: Personal information removed

Can anyone advise how to do this in the hub control panel?

Thanks!

Re: How to open up port 3306 in Plusnet Hub 2

dvorak — Tue, 06 Jun 2023 11:37:43 GMT

the XXXX.plus.com is the identifier of your home connection.
If you need to access a DB running on your home network you need to set up port forwarding in your router.

This can be configured here http://192.168.1.254/firewall.htm in the Hub2.

Re: How to open up port 3306 in Plusnet Hub 2

PaulFreeland — Tue, 06 Jun 2023 11:57:52 GMT

Thank you

I am trying to access a remote MySQL database. i.e. it's an outgoing connection.

For example this is my terminal command:

mysql -uroot -p -h myremoteserver.co.uk

This prompts for the password and then show this error message:

Access denied for user 'root'@' [Removed].plus.com' (using password: YES)

It seems as though myremoteserver.co.uk is being redirected to my home connection identifier which I assume is being done by the router (?)

The router firewall is set to Default - allow all outgoing connections

Can you advise please?

Moderators Note: Personal information removed

Re: How to open up port 3306 in Plusnet Hub 2

dvorak — Tue, 06 Jun 2023 12:00:13 GMT

It's blocked at your remote end, the message is saying your ip address / host is blocked.
You will need to allow access on the remote server.

Re: How to open up port 3306 in Plusnet Hub 2

PaulFreeland — Tue, 06 Jun 2023 12:26:09 GMT

Thank you very much, granting access to my new IP sorted it.

In my defence the error message is very confusing 🙂

Re: How to open up port 3306 in Plusnet Hub 2

dvorak — Tue, 06 Jun 2023 13:34:09 GMT

Glad it's sorted for you

Re: How to open up port 3306 in Plusnet Hub 2

MisterW — Tue, 06 Jun 2023 13:45:14 GMT

granting access to my new IP sorted it.

I hope access isn't really granted on a specific IP basis. Unless you have opted for a static IP, then there is a possibility you may be allocated a different IP should the connection ever be reset e.g by Openreach maintenance or a router reboot

Re: How to open up port 3306 in Plusnet Hub 2

dvorak — Tue, 06 Jun 2023 13:49:37 GMT

judging by the host name returned by the access denied message, I'd say it was static.