Newbie question: setting up development server with Lucee and MySQL

[Thane Sherrington]

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.

[Matt Hall-Smith]

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

--
You received this message because you are subscribed to the Google Groups "CommandBox" group.
To unsubscribe from this group and stop receiving emails from it, send an email to commandbox+...@ortussolutions.com.
To view this discussion on the web visit https://groups.google.com/a/ortussolutions.com/d/msgid/commandbox/06707b6c-ddf6-4dd6-a6f2-e0f79848f832o%40ortussolutions.com.