Student Project Server Documentation
Note: You may not be using all of the following options for your course. These instructions are listed for any courses requiring them.
- HowTo Videos
- Using the Linux System
- Accessing the MySQL Database
- Using PHP
The Linux System
Accessing the MySQL Database
- A database has been created, which has the same name as your login and home directory. Type
mysql -p databasename
to use the mysql command line monitor (where databasename is your database (login) name). You will be prompted for your password.
- Once you are in your MySQL database, type \h (for HELP) to get the basic command list. \q is the command to quit. The other commands can be found in the MySQL Reference Manual below.
- MySQL Reference Manual
- To create tables and table entries, follow the instructions given in your course materials and in the reference materials above.
- You are the only one who can read or write to your database from the command line.
- Note: Due to connection issues, we no longer recommend using a graphical client to connect to your database, such as MySQL CC, via SSH tunneling.
Warning: Do not attempt to change either your MySQL password or your user configuration in the mysql database. These have been set to enable access from both the Web and the command line and changes made can result in loss of that access. If you feel that permissions need to be changed, please contact the SCIS technical team.
Using PHP on the Server
- You will place any PHP files in the 'public_html' subdirectory of your home directory (/home/login/public_html). To access these from the Web, the URL will be http://student.athabascau.ca/~login/filename.php. Note: Substitute your login name and the filename you wish to access.
- PHP Basic and MySQL Connect Demos
- PHP Tutorial
Updated October 26 2016 by FST Technical Staff