Personal tools

SQL/Application

Document Actions
  • Send this
  • Print this
  • Content View
  • Bookmarks

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.
Copyright 2008, by the Contributing Authors. Cite/attribute Resource. jones. (2007, November 13). SQL/Application. Retrieved February 08, 2012, from Dixie State College of Utah Web site: http://dixie.educommons.net/computer-and-information-technology/systems-design-and-adminsitration-i/sql-application. This work is licensed under a Creative Commons License. Creative Commons License