Creating the Viewpoint database

Installing/upgrading Viewpoint > Before installing Moab Viewpoint for Moab HPC Suite > Creating the Viewpoint database

1.1.1 Creating the Viewpoint database

The Viewpoint database must be one of the following:

MySQL 5.1 +
Oracle 10g Express 10.2 +

You must create the database and give the user full access to that database. The following example uses MySQL. For information on creating databases and granting access with other database vendors, consult the documentation for that vendor.

To create the Viewpoint database

Remembering to run commands in context, run a code such as the following:

adaptive@viewpointMoab Viewpoint:~$ mysql -u admin –p viewpoint
Enter password:
mysql> CREATE DATABASE viewpoint;
Query OK, 1 row affected (0.08 sec)
mysql> GRANT ALL ON viewpoint.* TO viewpoint@localhost IDENTIFIED BY 'p@ssw0rd';
Query OK, 0 rows affected (0.31 sec)
mysql> GRANT ALL ON viewpoint.* TO [email protected] IDENTIFIED BY 'p@ssw0rd';
Query OK, 0 rows affected (0.31 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.31 sec)

Verify that it ran correctly. This can be done by running a third party client such as SQuirrel SQL or by using your database vendor's own client tool (for instance, in MySQL you would run mysql -u <username> -p <password>.).