accessing the mysql database used by AppDynamics UI tool

[CommunityUser]

Hi,

We recently bought the license and had AppDynamics installed on a Linux box. We can view the UI tool and have configured it to monitor some databases.

We can tell that AppDynamics is using a MySQL database on the Linux box. Can we access and query this MySQL database? Does AppDynamics encourage users to access this MySQL database which is being used by the AppDynamics UI tool?

Thank you.

[Jean-Baptiste_M]

Hello Jwang,

Yes we do use a MySQL database under the hood.

However, we don't encourage our users to directly query the DB for extracting data or for interacting with the product but we do recommend to use the API https://docs.appdynamics.com/display/PRO42/AppDynamics+APIs for different reasons (performance, stability, support, etc).

However, sometimes we connect directly to the DB for some rare admin tasks (ie changing the root pwd for example).

You can only connect to it locally on the controller, have a look here:

https://docs.appdynamics.com/display/PRO42/Reset+Root+User+Password

Now it all depends on what you are trying to achieve, right?

Hope it helps

Best