Omega

until the system is at 100% you can email kbrandst@hawk.iit.edu if you would like an account

Omega -- Create a Database

Database creation temporarily disabled until a CAPTCHA system is implemented.



Please note this page is in the process of being updated to reflect the addition PostgreSQL, even though there are not yet instructions on how to use PostgreSQL, you can still request a DB, and search online on how to use it.

Step 1

   Creating your own database on Omega is as easy as filling out the following form. Read on to learn how to access and work with your new database once it is created.

Your Omega Username *
Your IIT E-mail address *
Type of Database *
Database Name *


Step 2

   The first thing you need to do once your database is created is change your MySQL password. Do this by issuing the following command, replacing 'new_password' with the desired password:

<username>@omega ~ $ mysqladmin -p password 'new_password'

Step 3.1

   To access your database using the MySQL frontend, issue the following command. Once you're in, you can issue SQL commands as usual.

<username>@omega ~ $ mysql -p 'your_database_name'


Step 3.2

   If you are planning on using your database with PHP, you will have to tell your PHP page where the database resides, what username and password to use to connect to it, and what the database is called. Use the following snippet of code to establish a connection:

$linkID = mysql_connect ('localhost', 'your_username', 'your_mysql_password');
mysql_select_db ('your_database_name', $linkID);

   A simple class that demos the most common MySQL functions and handles simple errors is here. Browse through the code to learn the basics about connecting and disconnecting, and issuing queries.

   The PHP Manual has an excellent guide on connecting to MySQL from PHP, and a complete reference for all PHP MySQL functions. It is located at http://www.php.net/manual/en/ref.mysql.php.


Step 3.3

   Finally, if you are planning on using your database with Perl, read through the following tutorials to find out how.

Introduction to MySQL (using Perl DBI)
http://www.danchan.com/feature/2000/10/16/mysql/mysql.htm

DBI - The Perl Database Interface
http://dbi.perl.org/


Step 4

Official MySQL Tutorial
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html

SQL Tutorial
http://www.w3schools.com/sql/default.asp


Step 5

   Questions, problems, comments? Email us!