Msql does not have the same notion of accounts and permissions that Oracle has, the only priveliged operation is creating a new database, which can only be done by a member of the products group on cdfsga.
Database creation is done with the msqladmin command.
Metadata is viewed with the relshow command.
Msql data is viewed and manipulated from the command line with the msql command.
Msql databases can also be accessed programmatically from C using ODBC or the Msql API, from java using JDBC, from perl using DBI, and from python.
cdfsga% ups list -a msql
DATABASE=/cdf/offln/offline/upsdb
DATABASE=/cdf/code/cdfman/upsdb
DATABASE=/usr/products/upsdb
Product=msql Version=v1_0_16 Flavor=IRIX
Qualifiers="" Chain=""
Product=msql Version=v1.0.13 Flavor=IRIX
Qualifiers="" Chain=current
Product=msql Version=v2_0_4_1 Flavor=IRIX
Qualifiers="" Chain=""
cdfsga% setup msql v2_0_4_1
cdfsga% relshow jack_db
Database = jack_db
+---------------------+
| Table |
+---------------------+
| t1 |
| QIE |
| QIEtest |
| QIEtest2 |
+---------------------+
cdfsga% msql jack_db
Welcome to the miniSQL monitor. Type \h for help.
mSQL > select * from t1
-> \g
Query OK. 1 row(s) modified or retrieved.
+----------+-------+
| foo | bar |
+----------+-------+
| 1 | one |
+----------+-------+
mSQL > \q
Bye!
cdfsga%