Table of ContentsView in Frames

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.

About this task

There are many ways to connect. The following shows one way.

When accessing MySQL, consider the following issues:


  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               |