Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Create the repository database > Create a MySQL repository database

Create a MySQL repository database

Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 81 Votes: 0 Revisions: 2

After you install DPA and open it for the first time, you must create a repository database.

To use a MySQL instance as the repository database:

  1. On the Select Repository Database Instance Type page, click MySQL.
  2. Click Next.

Enter connection information

SolarWinds DPA creates a new database and populates it with tables, indexes, and initial data.

Connection information

Enter the server name or IP address and port. The default port is 3306.

Do not use a critical production database.

MySQL repository administrator

Select a method for creating or configuring the MySQL repository administrator:

Create the user through SolarWinds DPA

The credentials for the privileged user are not used or stored after the registration.

  1. Click Provide a privileged user.
  2. Enter the credentials of an existing user with privileges to create the repository user and grant the required permissions.

    The privileged user requires the Create, Drop, and Create User permissions and must be able to grant the following permissions:

    GRANT ALL PRIVILEGES on <databaseName>

    Where <databaseName> is the repository database you create or select when you set up the MySQL repository storage.

Create the user manually

  1. Click Provide the repository user.
  2. Enter credentials. SolarWinds DPA encrypts the password.

Alternatively, you can use the script that SolarWinds DPA provides to create a repository user.

  1. Click Repository DB and User Creation Script, and follow the on-screen instructions.
  2. Copy the edited script to the MySQL console, and run it.
  3. Provide this user as your repository user.

Enter repository login

If you provided the repository user in the previous step, the wizard skips this step.

Allow DPA to create the user

SolarWinds recommends this method because DPA requires special permissions that existing users may not have.

  1. Next to Create New User, click Yes.
  2. Enter the user name and password.

Create the user manually

  1. Next to Create New User, click No.
  2. Enter the user name and password.

Specify database for the repository

Choose whether to store the repository in a new or existing database.

New database

Enter a database name. SolarWinds DPA prefixes the name with dpa_ for identification.

Existing empty database

This option is available if the repository instance contains an empty database.

If your MySQL Administrator created a database for SolarWinds DPA, select the database from the list.

If you provided a privileged user, SolarWinds DPA only displays tables with Select permissions granted to the privileged user.

No database permissions are required while using the privileged user. SolarWinds DPA grants the required permissions to the specified user when creating the repository.

If you provided the repository user, SolarWinds DPA only displays tables with Select permissions granted to the repository user.

The All privilege is required to use the database.

Contact information

Enter your name and email. SolarWinds DPA sends database performance reports to this address.


  1. Confirm the repository information, and click Create Repository.
  2. Click Register Database Instance to Monitor to continue.
Last modified
13:51, 15 Sep 2016