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

MySQL 5.1 is the supported database for Viewpoint. You must create the database and give the user full access to that database. For information on creating databases and granting access with other database vendors, consult the documentation for that vendor.

MySQL and Oracle are currently the only supported databases for Viewpoint. However, the use of other databases with Viewpoint is possible. Please contact Adaptive Computing Support for more information.

For information on creating databases and granting access with other database vendors, consult the documentation for that vendor.

To create the Viewpoint database

Run something like the following script. (Remember to run commands in context.)

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 the script ran correctly by running a third party client such as SQuirrel SQL or by using your database vendor's own client tool (for instance, run mysql -u <username> -p <password>).