I'm on the Jenkins ver. 2.176.1.
I wish to connect to mysql database by passing host, port, and credentials in Jenkins pipeline for SELECT / INSERT queries to an existing database table. As, I have understood there is no good plugin that works for MySQL connectivity (tried a couple which do not mask the password); I decided to set the MySQL hostname and Port as environment variables and username and password as credentials in Jenkins. I have three plugins installed for this purpose viz. Credentials plugin, Credentials Binding plugin,Plain Credentials plugin. [image: Jenkins Credential Plugins] I then setup mysql credentials by clicking: Jenkins->Credentials->System->Global credentials (unrestricted) [image: Mysql credentials] Now; in-order to generate code for pipeline for accessing these credentials i go to-> http:///pipeline-syntax/ see below snapshot: [image: Syntax Generator] Below are three queries I have: 1. The credentials drop-down (marked with *RED ARROW* in the snapshot above) in the pipeline syntax generator does not populate anything & seems disabled. I was expecting the mysql credentials ID to show up in the drop-down as expected. Can you suggest what could be the issue here ? Also, I have administrator role. 1. 2. I need the syntax to pass the MySQL username and password as variables to a different Jenkins job from my pipeline script below. Please suggest how can I ? steps { build job: 'myjob1', parameters: [string(name: 'Region', value: "${params.Region}"),<mysql-username>,<mysql-password>)] } 3. Is there Alternate / better solution than the one I chose for Masking Database credentials ? -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/8afa06c2-aafe-43b8-9316-d6aea25ff2b0%40googlegroups.com.
