dbFront currently supports MySql 4 and MySql 5.
MySql Server connectivity is reasonably easy to setup but it does require a separate driver download.
To use MySql with dbFront you need to download and install the MySql drivers:
- Connector Download at MySQL.com
- Note: Please download version 6.9.x of the MySQL Connector. Newer versions are not yet supported.
To find the correct version you may need to look for and click on the link "Looking for previous GA versions?"
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 servername 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 to proceed to connecting to a database and starting the setup of a web application.