dbFront currently supports MySql versions 4, 5 and 8.0.
MySql Server connectivity is reasonably easy to set up but it does require a separate driver download.
To use MySql with dbFront you need to download and install the MySql drivers:
- Note: Download version 6.10.x of the MySQL Connector. Newer 8.x versions are supported but require a messy install.
- Connector Download at MySQL.com
- To find the correct version you may need to look for and click on the link "Looking for previous GA versions?"
Installing the 8.x connector
For some reason, the 8.x connector will complain about not being able to find its own components after it is installed and used directly. One ugly solution is to copy the driver files directly into the dbFrontService folder, usually c:\program files (x86)\dbFront\. I am currently investigating better solutions.
Connecting to a default install of MySql is normally straight forward. If the install is on a different server then you would just specify the server name or IP address. If the server is on the same server as the dbFront Application server then you can use the name LOCALHOST to connect to the local server install. The default settings for MySql are:
- Protocol: TCP/IP
- Port: 3306
Remote MySQL Databases
It may be tempting is to connect to an instance of MySql that is hosted offsite at an ISP. Although this will work, the performance will most likely be terrible because of the network latency between the application server and the database server.
To check the latency you could ping the database server and look at the response time.
Development MySQL Server Install
If you want to install a version of MySql on a windows workstation for development or functionality testing then a good option to consider is WampServer. Just don't attempt to use this for production use.
The next step would be connecting to a database and starting the setup of a web application.