Reach MySQL from the outside

[Club AC-News]

Hi,

I have a cubietruck 3 with a Debian "Buster".

I am looking to connect to the MySQL server to reach an outside database. Everywhere, it is said to comment out the line containing "bind-address = 172.0.0.1". This is done and the server listens on all ports.

I still can't reach it, there must be something else to do but the tutorials don't say it.

Thanks

[martinayotte]

10 minutes ago, Club AC-News said:

I still can't reach it

Did you try to bind to 0.0.0.0 ?

https://serverfault.com/questions/139323/how-to-bind-mysql-server-to-more-than-one-ip-address

[Club AC-News]

58 minutes ago, martinayotte said:

Did you try to bind to 0.0.0.0 ?

The problem is always present.

I think it is the server where MySQL is installed that is blocking. If I start a connection through an SSH as root, I can connect to it remotely. I am using Lazarus and in the connection component, I cannot create an SSH connection.

 

PS : I think I have found, I did not open port 3306 on the router. I can't do it until tonight. I am not there.

Thanks

[martinayotte]

4 hours ago, Club AC-News said:

I did not open port 3306 on the router.

Of course, in this case ...

Be careful about security, you can also choose another port number for outside network, preventing hackers ...

[Club AC-News]

Yes, It was that.

about security, you can also choose another port number for outside network, preventing hackers ... -> Yes, it's only for a test, a pre-project and therefore temporary.

I will then communicate the database to the IT department who will host it on their server and the necessary security.

Thanks

François

[Werner]

18 hours ago, martinayotte said:

you can also choose another port number for outside network, preventing hackers ...

security through obscurity was never a good practice IMHO...

Though I have to admit that I change my SSH ports too to avoid background noise spamming the logs

[xwiggen]

On 8/2/2020 at 2:56 PM, Club AC-News said:

 

 

a client for amavisd-new is using 3306 on localhost (ipv4), stop it, wait for it to clear, restart mysqld, check, then start amavisd.

 

@Werner sshguard works excellent.