Database Management

Due : November 6, 2009

Assignment: 
Install and configure a DBMS server.

Requirements: 

• Install the DBMS and configure it for security.
• Configure the DBMS for use by local users and limited network users.
• Create and configure a simple web application to use the new database

This work is to be completed on a new system created as the database server. Remember to configure DNS and SMTP correctly for this system. Also remember the SSH key assignment.

Install the DBMS and configure it for security: 


• Install the mysql-server and mysql-client packages.
• Configure the root mysql account with an appropriate password.
• Remove any unnecessary default accounts and databases from the configuration. This includes accounts with no name, and the databases with test in their names.

Configure the DBMS for use by local users and limited network users: 


• Create a new database.
• Create a new user that has normal access privileges to the new database.

Create and configure a simple web application to use the new database: 


• Create a simple connectivity test web application.
• Configure the application to use the new database and user created above.
• Install the correct packages on the web server to activate the web application.

Pass-off Procedure: 


• Using the CIT submission system, submit a file to IT3100, DBMS - Management.
• The file should be named dbms_info.txt. This file must be a plain text file, with the following format:

  mysql: ip_address_of_the machine with mysql server installed.
  url:   url of the simple web application.