Accessing MySQL using the command line interface

In addition to accessing Data Warehouse data elements through the report authoring tools (such as Query Studio and Report Studio), you can obtain access to Data Warehouse data elements directly by connecting as a MySQL user. You might want to connect as a MySQL user to use the data elements in your own applications.

1. On the machine where Data Warehouse is installed, open a command line window.
2. Access the MySQL directory in the OnCommand Insight directory.
3. Type the following user name and password:
   mysql -udwhuser -pnetapp123

   The following is displayed, depending on where Data Warehouse is installed:

   c:\Program Files\OnCommand Insight\mysql\bin> mysql -udwhuser -pnetapp123

   Welcome to the MySQL monitor. Commands end with ; or \g.
   Your MySQL connection id is 882
   Server version: 5.1.28-rc-community MySQL Community Server (GPL)

   Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

4. To show the Data Warehouse databases, type the following:
   show databases

   The following is displayed:

   mysql> show databases;
   +-------------------------+
   | Database                |
   +-------------------------+
   | information_schema      |
   | dwh_capacity            |
   | dwh_capacity_efficiency |
   | dwh_fs_util             |
   | dwh_inventory           |
   | dwh_performance         |
   | dwh_ports               |
   +-------------------------+