I have been attempting to track Stored Procedure changes in a MySQL DB using our Liquibase Pro trial. Not sure what else to try at this point, any and all ideas are appreciated!
The Problem
The command liquibase generate-changelog --changelog-file=changelog.xml is returning a null sql text file in the /objects/storedprocedure directory. These docs have carried me to this point.
Setup
MySQL Server 8.0.32
Connector/J 8.0.32
Windows 10 Business
liquibase.config
# Enter the path for your changelog file.
changeLogFile=changelog.mysql.xml
# Enter the Liquibase Pro trial license key
liquibase.licenseKey: REMOVED FOR POST
#### Enter the Target database 'url' information ####
liquibase.command.url=jdbc:mysql://localhost:3306/liquibase_demo_dev
# Enter the username for your Target database.
liquibase.command.username: root
# Enter the password for your Target database.
liquibase.command.password: 123456
#### Enter the Source Database 'referenceUrl' information ####
## The source database is the baseline or reference against which your target database is compared for diff/diffchangelog commands.
# Enter URL for the source database
liquibase.command.referenceUrl: jdbc:mysql://localhost:3306/liquibase_demo_test
# Enter the username for your source database
liquibase.command.referenceUsername: root
# Enter the password for your source database
liquibase.command.referencePassword: 123456
Attempted resolutions
Granted all recommended permissions to the current user per this article
Created a new MySQL user to match the authors name displayed in the changeset and granted all permissions from #1
Verified that the liquibase.properties file is set to the correct user
Other changesets are pulling through, so I believe the connection information is accurate in some regards
Ensured that the Stored Procedure ‘Definer’ matches the MySQL user with recommended permissions
Changed the default object editor delimiter in work bench to ‘//’ from ‘$$’
