My local MySQL server has a single user of "root" and the password is an empty string. (it's for local dev only). When I add a datasource and then go back and edit it in the interface to see the code I need to add to my Application.cfc, it omits both the username and the password from the code even though they are required to connect.
Please keep the username and password in the code even if they are blank. Or at least the username, even if there is no password.
The issues occurred due to a If condition on ( https://github.com/lucee/Lucee/blob/5.1/core/src/main/cfml/context/admin/services.datasource.create.cfm#L546 ). Need to remove the condition for displaying the username and empty password.
please give this a try and report back here
I've checked this ticket and works as expected from the fixed version.