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 > Server & Application Monitor (SAM) > SAM error Monitoring MySQL database server. ODBC data source returned an error. [MySQL][ODBC 5.1 Driver]Host '10.199.15.46' is not allowed to connect to this MySQL server.

SAM error Monitoring MySQL database server. ODBC data source returned an error. [MySQL][ODBC 5.1 Driver]Host '10.199.15.46' is not allowed to connect to this MySQL server.

Created by Aileen de Lara_ret, last modified by MindTouch on Jun 23, 2016

Views: 53 Votes: 1 Revisions: 2

Overview

This article provides brief information and steps to resolve the following error:

SAM error Monitoring MySQL database server. ODBC data source returned an error. [MySQL][ODBC 5.1 Driver]Host '10.199.15.46' is not allowed to connect to this MySQL server. 

 

Environment

All SAM versions

Resolution

Example:

Assume the IP address of your Orion server is 10.199.15.46.

To grant access to this IP address, enter the following command in mysql> prompt for existing an database:

      mysql> update db set Host='10.199.15.46' where Db='webdb';
      mysql> update user set Host='10.199.15.46' where user='webadmin';

 

 

 

 

 

Last modified
03:33, 23 Jun 2016

Tags

Classifications

Public