External MySQL Database

[michaelhoffman]

Hello,

I was wondering if it's possible for me to connect to my MySQL database externally? At the moment it only allows "localhost:3306".

 

Kind Regards,

Michael Hoffmann

[wolstech]

Yes, you just have to enable remote access in Plesk. To do that, you edit the database user. The options for remote access are at the bottom of the permissions page.

Once it's enabled, you simply connect to tommy.heliohost.org:3306 with a client app.

[michaelhoffman]

Hi wolstech,

 

I am getting this error when trying to connect my app to the DB: "🔥 Fatal login error: Error: getaddrinfo ENOTFOUND tommy.heliohost.org:3306" The hostname "tommy.helihost.org:3306" cannot be found by the app. 

 

I've got the below option checked, is there somewhere else I need to enable external DB access, or is there a different hostURL I need to use?

 

EDIT: nevermind, issue was I was keeping the :3306 when I didn't realise I already had a separate environment variable for the port so it was double porting the URL.

Kind Regards,

Michael Hoffmann

Edited 4 hours ago by michaelhoffman