Accounts: MySQL

From WolfTech
Jump to navigation Jump to search

Creation

Databases are created for projects on an as-needed basis. To request, send email to ece-webmaster@ncsu.edu. You will need to include:

  1. Name of the project.
  2. Names and Unity IDs of project participants.
  3. Names and Unity IDs of those who will have access to the database (if different from 3.)
  4. How project relates to ECE.

Format

All databases are assigned three username/password combinations with the following attributes:

<database name>-rd : SELECT
    Use in code when page will be used only to retrieve information from database.
<database name>-wrt : SELECT, INSERT, UPDATE, DELETE
    Use in code when page will be used to make changes to database.
<database name>-adm : SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
    Use only for logging into PHPMyAdmin to set-up database structure. NEVER USE IN CODE.

Deactivation

Administrative (-adm) accounts are deactivated upon completion of the project. Read (-rd) and write (-wrt) accounts may remain active as long as the completed project requires.