Install MySQL for WebReports

WebReports can use MySQL for its application database.

Use this article to install MySQL Server and MySQL Workbench and create the MySQL account that WebReports will use.

Before You Begin

Before installing MySQL:

• Confirm that you have administrator access to the Windows server.
• Review the WebReports Deployment Requirements and Network Architecture.
• Determine the MySQL server name, port, and database-account credentials that will be used by WebReports.

Download MySQL

Download the MySQL Installer from the official MySQL website:

Download MySQL Installer

If prompted to sign in or create an Oracle Web Account, select No thanks, just start my download to continue without signing in.

Install MySQL Server

1. Run the downloaded MySQL Installer Community MSI.

2. On the Choosing a Setup Type page, select:

   Server Only

3. Click Next.

4. Review the products that will be installed.
5. Click Execute.
6. Wait for the MySQL Server installation to complete.
7. Click Next to begin product configuration.

Configure MySQL Server

Type and Networking

Configure the Type and Networking options appropriate for your WebReports environment.

Verify the port that MySQL will use. The default MySQL port is:

3306

If WebReports and MySQL are installed on different servers, confirm that the required network and firewall rules allow communication between them.

Configure Authentication

Select the MySQL authentication method appropriate for your environment and organizational requirements.

Configure the Root Account

Enter and confirm a strong password for the MySQL root account.

Store the root credentials according to your organization's credential-management policies.

The MySQL root account should not be used as the routine WebReports application account.

Create a WebReports Database Account

Create a separate MySQL account for WebReports.

1. Click Add User.

2. Enter the account information.

   Example username:

   WRAdmin

3. Enter and confirm a strong password.
4. Assign the database privileges required for administering the WebReports database.
5. Click OK.

Record the username and password securely. These credentials will be required when configuring the WebReports database connection.

Configure the MySQL Windows Service

Configure the Windows Service options according to your environment.

In most environments, MySQL should be configured to start automatically with Windows.

Click Next when the service settings are complete.

Apply the MySQL Configuration

1. Review the configuration steps.
2. Click Execute.
3. Wait for each configuration step to complete successfully.
4. Click Finish.
5. Complete the remaining MySQL Installer prompts.

Install MySQL Workbench

MySQL Workbench provides a graphical interface for administering the MySQL server and database.

Download MySQL Workbench from:

Download MySQL Workbench

1. Run the downloaded MySQL Workbench installer.
2. Click Next.
3. Select the installation location, or keep the default location.
4. Select Complete as the setup type.
5. Click Install.
6. Approve the Windows installation prompt if displayed.
7. Wait for the installation to complete.
8. Click Finish.

Verify the Installation

After installation:

1. Open MySQL Workbench.
2. Connect to the MySQL Server.
3. Verify that the WebReports database account can connect successfully.
4. Record the server name, port, username, and password that will be used when configuring WebReports.

Next Steps

Before deploying WebReports, configure the MySQL storage settings required by WebReports.

See:

Adjusting MySQL Data Storage Settings for WebReports

For the complete Windows installation sequence, see:

Installing WebReports on Windows