DATABASE HOST

sunshinedev

Hello, I'm trying to link the database with an external site of mine and I can not, where can I see the host of my databases that are created in the panel?

toaitran

To connect to your database remotely, you should:

Open port 3306 (please open with caution, since other can be connect too, so you can open with specific IP only)
Your DB host should be: IP😛ORT (if MySQL, it should be IP:3306, or so)

sunshinedev

Thank you helped me a lot, however now says that my ip is not allowed

toaitran

It seems that I gave you some missing information, please try this:

Go to Database > create new database, and specify who can connect (local, everyone, specific IP) => try to connect again.

If it still not work, you can try the following:

Go to App stote > MariaDB > Settings > Configuration > add skip-networking=0 & skip-bind-address to mysqld block, then save configuration and restart MariaDB
Connect again with the database you created above (everyone option or specific IP)

My instruction base on this: https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/, you do not need to care about my.cnf file, as using the configuration on aapanel dashboard is enough.

Goodluck!