saibala,
Good questions! Let’s begin with the understanding that Infobright is running in a VM with no GUI interface installed. The VM (guest system) is running on your desktop (the host system). You can access Infobright in the guest system from GUI tools in your host system by supplying the correct connection parameters in the tool you choose to use. These parameters include the hostname, port number, user name, password and schema name. You can supply the IP address of your VM as the hostname.
The IP address of the VM can be found by running the ‘ifconfig’ command at the VM’s Ubuntu command line (see README file supplied with the Jaspersoft/Infobright VM download). The default port number is 3306 and the schema name is foodmart (for Jaspersoft - sampledata for Pentaho).
To determine user name and password you will either need to create a new user in MySQL (see MySQL’s web site here for instructions on adding users) or grant external access privileges to an existing user such as root.
One can view all Users by:
mysql> use mysql;
mysql> select Host, User from User;
For example, grant root access to everything from any location:
mysql> grant all privileges on *.* to root@'%' identified by '<password>';
Tools I use include MySQL Query Browser and Navicat Lite, without any ODBC driver or other installed connectivity software.
Best of luck!
