Accounts: MySQL
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:
- Name of the project.
- Names and Unity IDs of project participants.
- Names and Unity IDs of those who will have access to the database (if different from 3.)
- 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.