Newbie question: setting up development server with Lucee and MySQL

Communities CommandBox CLI
1

Hi all,
I apologize if this isn’t the right place for this, but I’m reading through the Commandbox documentation and I’m a bit lost.

I’m transitioning some old applications from ColdFusion with Access to Lucee with MySQL, and I want to setup a development environment on my laptop.

Is there a guide for this somewhere? As far as I can tell Commandbox gives me a Lucee server (and I have that running) but I’m not sure how to get MySQL setup.

Thanks for your time.

2

Hi there,

Install MySQL & MySQL Workbench from here https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Create a DB inside MySQL using MySQL Workbench and give it a DB Name.

Then with CommandBox session open, go to the Lucee Server and enter a Datasource for your MySQL instance.

Name [a name for this Datasource that you can use in your cfquery calls]
Host/Server Localhost
Database [your MySQL DB Name]
Port 3306
Username [for MySQL]
Password [for MySQL]

You will see error messages if something is not right and a green OK if all is well with the MySQL connection.

Also ensure that your local firewall allows traffic on 3306.

Cheers, Matt