Creating a blank database

MySQL

Database management for MySQL can be done from the command line or using a GUI tool. Two GUI tools that work well for MySQL are Navicat (commercial info at http://www.navicat.com/) and MySQL Administrator (free download at http://www.mysql.com/products/tools/administrator/). The instructions here are based on the MySQL Administrator.

Steps for creating a new blank database using GUI tool:

1. Launch the MySQL Admin progam
2. Click on Catalogs
3. Create a new catalog
1. On a Mac click the “plus” button
2. On Windows right click in the schemata area or Ctrl-N
4. Give the database a name. This is the name that will be used to access the database by users and administrators

And to create a new blank database using the command line:

create database [DB_NAME] default character set 'utf8' default collate 'utf8_general_ci';

("[DB NAME]" can be assigned to any name you choose; however, the name needs to be expressed in all uppercase characters)

The Oracle work should be done by an Oracle DBA (Database administrator).

The command for creating the blank database is:

create database [DB NAME] default character set 'utf8' default collate 'utf8_general_ci';

Oracle setup procedures followed by Penn State University staff (Jan 2012) are included below.

Content to be written

Installing the back end database server | Initializing Overview | Creating user accounts for using and managing the database