VRMIDTOWN Database Server
The point of having a database is to keep track of large amounts of information that is needed for whatever services that require it. Currently the MySql database is used for the user database and online editing functions. The user
database keeps track of users, their login status, and other vital information. The online editing database keeps track of what objects have been "checked out", important meta information, etc... Explanations of these databases are explained later.

General Notes You Really Need to Know:

Username:  vrmidtown
Password:  vrmidtown
Database:  vrmidtown

There is only one username and password for vrmidtown.  This will obviously need to be changed as the project progresses, but for now this has been the most convenient way to test/write the code/server.  Just be careful not to accidentally wipe out a database or kill the server.

We are currently using MySQL version 3.22.20a.

The current path of the database engine is /users/projects/class/vrmidtown/vrm/product/server/database

There are two versions of the database that have been implemented:
mysql-3.22.20a-sgi-irix6.3-mips
mysql-3.22.20a-sun-solaris2.6-sparc

This is because there are currently two MAIN ports of VRMIDTOWN (Irix and Solaris) and the database engines are not architecture independent.

There are currently two databases being stored on the VRMidtown Database Server:

 User Database
 Editor Database

If you need documentation on the MySql database, there is a very comprehensive  manual .  For more information, you can also go to  www.mysql.com  that will tell you everything you need to know.  I recommend visiting the MySQL website every so often to see if there are any useful updates.
 

Last edited: 5-22-99