MySQL is the world’s most popular open source database. Some of the main MySQL features are:
-
Scalability and flexibility
-
High performance
-
High availability
-
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. The 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 3.0.0.2023031411
Revised on March 21, 2023
Plugin procedures
| For the following parameter descriptions, required parameters are in bold italics. |
Plugin configuration
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/RO by going to the "Administration" tab and then to the "Plugins" sub-tab. The "Configure" link is on the right side of the row for the specific plugin, which will open the Configuration page.
| Parameter | Description |
|---|---|
Configuration Name |
Provide a unique name for the configuration. (Required) |
User Name |
Provide the user login ID. Login IDs are case-sensitive. (Required) |
Password |
Provide the user-specified password. (Required) |
ExecuteSQL
The ExecuteSQL procedure creates and executes a command line from the parameters that you provide in the procedure form.
| Parameter | Description |
|---|---|
Configuration name |
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) |
Database name |
Name of the database. This is the command-line '--database' option. (Required) |
Server |
The name or IP address of the server to which you want to connect. This is the command-line '--host' option. (Required) |
Port |
Database port. Default value is 3306. This is the command-line '--port' option. (Required) |
Output format |
Choose the output display format. |
Report name |
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. |
Query |
Provide any query you want to run against the database. This is the command-line '--execute' option. |
Additional commands |
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 |
Working directory |
Directory where the job will be executed. |
Result (output property path) |
Property name used to store the result of the queries. |
Release notes
EC-MYSQL 3.0.0
-
The plugin has been migrated to the PDK framework. Support has been added for the new plugin configuration.
EC-MYSQL 2.0.4
-
Fixed incorrect plugin behavior with non-unicode character sets.
-
Added a ConnectionEncoding field in the SQLExecute form that allows the plugin to work correctly in any encoding. The default encoding is UTF-8.
EC-MYSQL 2.0.3
-
Fixed an error during SQL execution from file.
-
Fixed error with plugin crash when reportName presents.