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.
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.