Connecting to MySQL

Follow

Overview

This article describes how to add a MySQL™ database as a datasource in BrightGauge™, a ConnectWise solution.

Connecting to a MySQL database consists of the following steps:

1. Download and install the BrightGauge agent on a computer or server on your network. Please refer to Installing the BrightGauge Agent for instructions.
2. Create a user in your MySQL database.
3. Connect to MySQL in BrightGauge.

Create a MySQL User

To create a MySQL user:

1. From the databse server, open SQLyog.
2. Select User Manager.
   
3. Click Add New User.
   
4. Enter a Username and a Password, then click Create.

   Note: Database passwords must consist of only alphanumeric characters (a-z and 1-9). 

   
5. Select the checkbox for the SELECT permission, then click Save Changes.
   

Connect to MySQL

To connect to MySQL:

1. Log in to your BrightGauge account.
2. Navigate to DATA > Datasources.
   
3. Select Add a New Datasource.
4. Select Database.
   
5. Select MySQL.
6. Complete all fields in the Name This Datasource, Agent, and Database sections.

   

   Name	Enter a name for the datasource.
   Agent Host	The external IP address of your BrightGauge agent computer.
   Database Internal IP/Hostname	The internal IP address of the database server. If using multiple SQL instances, enter the IP address or server name followed by the instance name. For example, 192.168.1.2\instance or SQLServer\instance.
   Database Name	The name of the database.
   Database Port	The SQL port number.
   Database Username	The username of your MySQL user.
   Database Password	The MySQL user password.

7. Click Test Connection. If the connection is unsuccessful, ensure that all fields are correct.
8. If the connection is successful, click Save.