This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Monitoring Mysql database

Hi,

I want to monitor mysql database server  .I have done the following things:

My database name is fahad

(i)I inserted the following query into the database

GRANT ALL PRIVILEGES ON "" TO 'jinnah'@'192.168.2.25' IDENTIFIED BY "xxxx"

username:Administrator  of the SAM server

Password:Password of the SAM server

(ii)Installed MySQL ODBC installed on APM server

(iii)During adding node to the application monitor  they have asked for Credential where I have given username as the database username and database password

But once it finishes testing it gives the following error

"Testing on node Mubin-PC:failed with 'Down' status Data source name not found and no default driver specified"

What shall i do.

Regards

  • The issue is likely the MySQL ODBC driver referenced in the template does not match the driver installed, or you installed a 64bit driver, and are referencing a 32bit driver. These are both common problems. I suggest reading the thread below for more details.