MySQL is the world’s most popular open source database. Some of the main MySQL features are:
Scalability and flexibility
Robust transactional support
Web and Data Warehouse strengths
Strong Data Protection
Ease of management
Lowest total cost of ownership
The EC-MySQL plugin interacts with the MySQL command-line tool,
mysql utility allows you to perform queries against the database from text areas or a SQL file. You can also apply custom formatting to output such HTML or XML. You can find more information at this website.
Plugin Version 220.127.116.112041809
Revised on April 18, 2022
|For all of the following parameter descriptions, the required parameters are in bold italics.|
Plugin configurations are sets of parameters that apply across some or all of the plugin procedures. They are intended to reduce repetition of common values, create predefined sets of parameters for end users, and to securely store credentials where needed. Each configuration is given a unique name that is entered in designated parameters on the procedures that use them.
Plugin configurations are created in CloudBees CD by going to the "Administration" tab and then to the "Plugins" subtab. The "Configure" link is on the right side of the row for the specific plugin, which will open the Configuration page.
Provide a unique name for the configuration. (Required)
Provide the user login ID. Login IDs are case sensitive. (Required)
Provide the user-specified password. (Required)
The ExecuteSQL procedure creates and executes a command line from the parameters that you provide in the procedure form.
The name of the configuration that contains the user and password to connect to the database server. (Required)
Mysql command line utility
Absolute path to the MySQL command-line tool. (Required)
Name of the database. This is the command-line '--database' option. (Required)
The name or IP address of the server to which you want to connect. This is the command-line '--host' option. (Required)
Database port. Default value is 3306. This is the command-line '--port' option. (Required)
Choose the output display format.
Name of the report that will be created after the query is run (without an extension).
SQL file path
Provide the absolute path to a SQL file that you want to run.
Provide any query you want to run against the database. This is the command-line '--execute' option.
You can enter these additional commands:
--table: This displays output in tabular format.
--verbose: This enables verbose mode.
You can find more commands at this website
Directory where the job will be executed.
Result (output property path)
Property name used to store the result of the queries.
Fixed incorrect plugin behavior with non-unicode characer sets.
Added field ConnectionEncoding in SQLExecute form, which allows the plugin to work correctly in any encoding. Default encoding - UTF8.
Fixed an error during sql execution from file.
Fixed error with plugin crash when reportName presents.
Fixed the bug where the clear text password appeared in the commandLine property created by the Execute SQL procedure.