SQL/Application

Assignment:
Install and configure a DBMS server and an application that uses it.

Requirements:

Install the DBMS and configure it for security.
Configure the DBMS for use by local users and limited network users.
Install and configure a web appliation to use the DBMS.

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:

For each group in the accounts assignment, create a database. Name the database after the group.
For each group, create a DBMS account. Name the mysql user after the group. Use an appropriate password.
Give the mysql users all normal privileges to their databases.

Install and configure a web appliation to use the DBMS:

Download and install phpBB so that the URL http://group.yourdomain/forum/ will find phpBB configured for the group users.
Customize the setup for the gargoyles.
Repeat the above steps for each of the groups.

Citation: jones. (2007, November 13). SQL/Application. Retrieved May 20, 2012, from Dixie State College of Utah Web site: http://dixie.educommons.net/computer-and-information-technology/systems-design-and-adminsitration-i/sql-application.