Question

Accessing mySQL from Delphi application

Posted July 9, 2021 180 views
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.

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.

×
Submit an Answer
1 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

by Mark Drake
Many websites and applications start off with their web server and database backend hosted on the same machine. With time, though, a setup like this can become cumbersome and difficult to scale. A common solution is to separate these functions by setting up a remote database, allowing the server...