CS Database services

MySQL Database

CS Department users can get MySQL database upon request.By default,users get the following the privileges:

SELECT, CREATE TEMPORARY TABLES, ALTER, UPDATE, CREATE, DROP, INSERT, INDEX, DELETE, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, LOCK TABLES

The name of the database server is mysql.cs.odu.edu and you can access it via one of the fast aliases.To find out more about using MySQL - visit: MySQL

To read about LOAD DATA INFILE with mysql, please read LOAD DATA INFILE

Oracle Database

CS Department users can get access to an Oracle database upon request.By default,users get the following the privileges:

SELECT, CREATE TEMPORARY TABLES, ALTER, UPDATE, CREATE, DROP, INSERT, INDEX, DELETE, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, LOCK TABLES

The name of the database server is oracle.cs.odu.edu. Once you have a database you can access it through Windows and UNIX.

UNIX Login:

• Login to one of the fast aliases
• At the prompt type source /usr/local/bin/coraenv
• When prompted for ORACLE_SID, type the SID provided to you by the administrators.
• For ORACLE_HOME choose /home/oracle.
• At the prompt type sqlplus xxxx@ZZZZ, where xxxx is the username and ZZZZ is the SID for your Database.

Windows Login:

• Login to either a Lab machine or VCLAB
• Go to C:/sqldeveloper
• Run sqldeveloper.exe
• Choose a custom connection name, enter the username and password for the Database, for hostname choose oracle.cs.odu.edu nad enter the proper SID.
• Press connect.