How to open up port 3306 in Plusnet Hub 2

[#1]

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!

[#2]

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.

[#3]

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

[#4 · Accepted solution]

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.

[#5]

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

In my defence the error message is very confusing 🙂

[#6]

Glad it's sorted for you

[#7]

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

[#8]

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