Have you tried connecting to it using a third party database application like SQLStudio Pro / DB Solo, etc.
There are 2 side to this.
- Are all your connection settings correct
Database Host / Address e.g. 149.28.79.214
Database Type e.g. MariaDB, MySQL, Postgres
Database Port e.g. 3306
Database Name e.g. myNewCloudDatabase
Database User e.g. root
Database Password
If you have all those credentials, and a third party database tool, and can connect, then you know that side is working fine first off.
If you get an error connecting with all the correct details, look at 2 things
-
Most Likely, is there a firewall blocking all connections that you need to open up on the database server side, and if that is the case, and you search google for âWhatsMyIPâ and enter your remote IP and it works then great, thats the issue.
This issue can cause the appearance of erratic behaviour, because one day you are connected perfectly, and the next day you not.
The reason for this is probably because your internet service provider changes your IP address dynamically, and each time they do you will have to open a new IP manually in the database firewall.
-
Less likely reason, the database has a read only user as well as a read/write user, I mention this because Hetzner loves auto creating those for you. An offshoot to this may also be that root is locked as a user by the system, and possibly you can not connect via root but rather a different username like admin which has the same privileges as root.