Accessing mySQL from Delphi application

Posted July 9, 2021
MySQL

I’m interested in getting a droplet, installing Ubuntu on it and running a mysql server. I would like to be able to access the mysql from within a delphi application. What I want to know is, if this will be possible without buying any 3rd party database connectors, or can I just use the standard FireDAC related components, like I would if the server was running on a local network.

Japster

Submit an answer

You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev • July 9, 2021

Accepted Answer

Hi there,

Yes, with all Droplets you would have root access, so once you’ve installed MySQL you will be able to configure it so that it accepts remote connections.

You can follow the steps on how to do that here:

https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

Hope that this helps. Regards, Bobby

Now Available: Managed MySQL Databases