Watch4net APG 5: Connecting to a MySQL database on Windows/Unix/Linux

Products

• VMware

Issue/Introduction

Symptoms:


Watch4net APG 5: Connecting to a MySQL database on Windows/Unix/Linux
How to connect to a MySQL database in Watch4Net APG 5

Environment

VMware Smart Assurance - Watch4Net/M&R

Resolution

This is useful when you want to access it for troubleshooting purposes.

Under Windows:

Start a command prompt and go to C:\Program Files\APG\Databases\MySQL\Default\bin\ and execute:

mysql u apg pwatch4net D apg

Under Unix:

APG provides a script to connect to the database under the bin directory, this script(mysql-client.sh) will propose you default answers:

bash-2.05# /opt/APG/bin/mysql-client.sh
 Enter username: [apg]
 Enter database: [apg]
 Enter password: ******** (default is watch4net)
 Mysql #

You can run various commands, for example:

show full processlist;    => List the current running procedures.

The APG database schema is available in the Doc/admin_backend.pdf directory.

Consult the official MySQL documentation for more information related specifically to MySQL.