How to properly connect to mysql database from outside?

Question

linux

There is a web-project on which I work only, but from 2 computers: home and work (hidden behind a proxy). In order not to install a Mysql server on each machine and then not transfer dumps, I would like to set up 1 database server so that I can connect to it from both machines, in the future I may have to connect from other places (so access by ip is not a good idea, since 100% I can only set it up for a home PC)
I would not really like to use the ssh tunnel option either, because. for me personally, this is not very convenient, but if there are no alternatives, I will use it.
Or if you set a good password for root, it will be possible to connect more or less securely without a tunnel?

Answer 1

Access to mysql can be opened both for one ip and for a mask.
Opening mysql for everyone is at least a bad idea. Even with super passwords, you will often be scanned and guessed passwords.
Raise on the machine where the mysql vpn server is. If you need to connect to the database from anywhere - connect VPN. And then mysql is already local.