Devart Forums

Hello group... I have a basic question about MySQL.

If I want to access a MySQL database on a local client machine using MyDAC for MySQL, do I need to install MySQL server, or does the libmysqd.dll library act as the server?

Thanks!
Bryan

libmysqld.dll is the MySQL Embedded server. You can use this server I you do not need remote connections to your database.

Antaeus,
Thank you for your reply.

I will need remote access to my database, but I also want to sycronize my remote database to a local database on the client side for when users are not connected to the internet.
In this case, they will choose to connect to the local client side database instead of the master remote database.
I will have to make the ability to syncronize the local client side to the remote master DB.

Will the libmysqld.dll work for this case?

Thanks for any expert advise you may have.
Regards,
Bryan

libmysqld.dll will not help in this case. You need one more instance of MySQL Server (not Embedded MySQL).
To synchronize information on your local and remote servers, you may setup replication.