Follow the instructions below to test the connection to the MySQL instance in the CDP Enterprise or Advanced Edition.
1. Click on "Policy" in the Main Menu to access the "Policies" page.
!p1.png!
2. Find the necessary Policy in the "Policies" list and click on the "Edit" icon in the "Actions" column for this Policy.
!p2.png!
{info:title=Tip}To find a Policy, you can use the Basic and Advanced List Filters. See [Customizing the Policies List].
{info}
3. The "Edit Policy" window will open. Select the "MySQL" tab.
!http://wiki.r1soft.com/download/attachments/22184395/mysql-tab.png!
4. On the "Databases" tab, click the "Test Connection" icon in front of the MySQL instance you want to test.
!p8.png!
{info:title=Note}Make sure that the correct database username and password are provided.
!p9.png!
{info}
5. The "Test Database Connection" dialog will open. Click "Test Connection."
!p7.png!
{info:Note}You can also test connection in the "Add New MySQL Instance" wizard. See [Adding MySQL Instance to the Policy].{info}
6. The results of the test will be displayed in a pop-up window. Click "OK."
!connected.png!
If the connectivity test fails, you will see the following message:
!connect-error.png!{excerpt:hidden=true}Instructions on how to test the connection to the MySQL instance. {excerpt}
1. Click on "Policy" in the Main Menu to access the "Policies" page.
!p1.png!
2. Find the necessary Policy in the "Policies" list and click on the "Edit" icon in the "Actions" column for this Policy.
!p2.png!
{info:title=Tip}To find a Policy, you can use the Basic and Advanced List Filters. See [Customizing the Policies List].
{info}
3. The "Edit Policy" window will open. Select the "MySQL" tab.
!http://wiki.r1soft.com/download/attachments/22184395/mysql-tab.png!
4. On the "Databases" tab, click the "Test Connection" icon in front of the MySQL instance you want to test.
!p8.png!
{info:title=Note}Make sure that the correct database username and password are provided.
!p9.png!
{info}
5. The "Test Database Connection" dialog will open. Click "Test Connection."
!p7.png!
{info:Note}You can also test connection in the "Add New MySQL Instance" wizard. See [Adding MySQL Instance to the Policy].{info}
6. The results of the test will be displayed in a pop-up window. Click "OK."
!connected.png!
If the connectivity test fails, you will see the following message:
!connect-error.png!{excerpt:hidden=true}Instructions on how to test the connection to the MySQL instance. {excerpt}