Embedded
Schedule Free Demo
Try it Free
Search results
Suggest a FeaturePDF

Connect to MySQL data source

The Bold Reports Designer supports connecting MySQL database using SQL Query.

Supported Server Versions: MySQL (5.1, 5.5, 5.6, 5.7, and 8.0)

Choose MySQL data source

  1. Click on the Data icon in the configuration panel. Data icon configuration panel
  2. In the DATA configuration panel, click on the NEW DATA button. New Data Panel
  3. In the connection type panel, choose the MySQL data source type. Connection types panel

Create MySQL data source with basic options

When you create a new data, the NEW DATASOURCE panel will show up with basic options,

  1. Specify the data source name without special characters, in Name field.
  2. In Server Name field, you need to specify the remote server name like myserver.domain.com.
  3. In Port field, you need to specify the Port number. Here, the default port number is 3306.
  4. Specify the username of your MySQL server in Username field.
  5. Specify the password of your MySQL server in Password field.
  6. Enable the Save password option to embed the credentials within the report when saving it in Report Server.
  7. Choose or enter an existing valid database. e.g. Northwind. Basic Option
  8. Click on the Connect to proceed with query design pane. Now, enter the required query and execute. Its corresponding values will be shown in grid for preview. New connection panel

    Only query mode is supported for MySQL data source.

  9. Click Finish to save the data source with a relevant name to proceed with designing report. New connection panel

Connecting to MySQL Datasource through SSH Tunnel

You can now connect to MySQL data sources through a secure SSH tunnel. This enhancement aims to offer a more robust and secure connection method, especially when accessing remote databases over insecure networks.

Enable-SSH

SSH Server Name: The address of the server running SSH.

SSH Port: The port number used for SSH connections (default is 22, but might be different).

SSH Username: Your authorized username for SSH access.

SSH Password: Your secure password for the SSH username (keep confidential).

SSH Tunneling is not applicable for MySQL datasource in the Bold Reports cloud version.

Create MySQL data source with advanced options

To connect the MySQL database with advanced options, click on the Advanced Options in New Data panel.

Advance Connection

Now, the panel is switched to advanced options. In advanced options, you can build your own connection string.

Set the connection string and input the username and password of MySQL server.

Advance Connection

Click on the Connect to proceed with query design pane. Now, enter the required query and execute. Its corresponding values will be shown in grid for preview. New connection panel

Only query mode is supported for MySQL data source.

Click Finish to save the data source with a relevant name to proceed with designing report. New connection panel

Click on Basic Options to switch back to the basic connection settings.

Switch Basic Option

Authentication types for advanced connection

You can set database credentials, prompted credentials, or use no credentials.

Advanced authentication

Authentication - A user name and password must be supplied to access the database, the credentials might be for a database login. The credentials are passed to the data source for authentication.

Advanced authentication

Enable the Save Password option to embed the credentials within the report when saving it in Report Server.

On report download action, the credentials will be not be saved with report data.

Prompt - When you configure a data source connection to use prompted credentials, each user who access the report must enter a user name and password on preview action to retrieve the data.

Advanced authentication

None - Choose the authentication type as None, when the authentication details or any other arguments required to connect with the data source are provided in connection string.