| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/MichaelMalz/CST1602/Labs/Lab01/ |
Upload File : |
<?
// JimMartinson/CST1602/Labs/Lab01/Lab01.phpinc
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
require('application.phpinc');
require('Gradebook/EvaluationSubmission_BEGIN.phpinc'); // Replaced.
$disabled = '';
$disabled = ' disabled'; // Comment this line to enable lab.
?>
<style type="text/css">b {white-space:nowrap;}</style>
<fieldset><legend>Description</legend>
The purpose of this lab is to demonstrate your ability to install MySQL Server and MySQL Workbench.
<?=$gradeNote?>
<? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><? } ?>
</fieldset>
<fieldset><legend><?=$evaluationType?> <?=$evaluationNumber?> Assignment</legend>
<ol class="count">
<li>
<a href="../../../Setup/ClassFolderSetup/?courseNumber=<?=$courseNumber?>&Labs=Labs" target="_blank">Setup a folder for the <?=$courseNumber?> class</a>.
</li>
<li>
Create a directory called <b><?=$evaluationName?></b> inside of your <b><?=$courseNumber?>\Labs</b> folder. We will use it for all work performed in this lab.
</li>
<li>
Install and configure MySQL Server.
<ol>
<li>If you have never installed MySQL server before please view the <a href="../../../Setup/MySQL/MySQL_Server_Installation">MySQL Server Installation</a> video.</li>
<li>Download the <a href="../../../Setup/MySQL/Install/mysql-5.5.52-win32.msi">MySQL Installer</a> (mysql-5.5.52-win32.msi) and save it in your <b><?=$courseNumber?>\Install</b> folder.</li>
<li>Go to your <b><?=$courseNumber?>\Install</b> folder and click on the <b>mysql-5.5.52-win32.msi</b> file.</li>
<li>Follow the directions to install MySQL server.
<br><span class="attention">IMPORTANT: Remember to change the install directory to <b>C:\MySQL</b>.</span> Note: You may have used a drive other than C: depending on your preference or computer setup.
<br><span class="attention">IMPORTANT: Remember the root password you set.</span>
</li>
</ol>
</li>
<li>
Install MySQL Workbench.
<ol>
<li>If you have never installed MySQL Workbench before please view the <a href="../../../Setup/MySQL/MySQL_Workbench_Installation">MySQL Workbench Installation</a> video.</li>
<li>Download the <a href="../../../Setup/MySQL/Install/mysql-workbench-community-6.3.7-winx64.msi">MySQL Workbench Installer</a> (mysql-workbench-community-6.3.7-winx64.msi) and save it in your <b><?=$courseNumber?>\Install</b> folder.</li>
<li>Go to your <b><?=$courseNumber?>\Install</b> folder and click on the <b>mysql-workbench-community-6.3.7-winx64.msi</b> file.</li>
<li>Follow the directions to install MySQL Workbench.</li>
</ol>
</li>
<li>
Install and setup the WebServices.cmd script.
<ol>
<li>If you have never installed WebServices.cmd before please view the <a href="../../../Setup/MySQL/WebServices_Installation">WebServices_Installation</a> video.</li>
<li>Download the <a href="../../../Setup/WebServices/WebServices.cmd">WebServices.cmd</a> and save it in your <b><?=$courseNumber?>\Install</b> folder.</li>
<li>Create a shortcut, move it to your <b><?=$courseNumber?></b> folder, and set it to run as administrator.</li>
</ol>
</li>
<li>Ensure you can start/stop the MySQL server.
<ol>
<li>
Run WebServices and ensure MySQL Server is running.
<br>Take a screenshot of the WebServices window and save it as <b><?=$saveFilename?>-WebServices.png</b> in your <b><?=$evaluationName?></b> folder.
<? showBegin('See Webservices example screenshot'); ?><br>
<img src="Webservices.png" width="682" height="340" alt="Webservices example screenshot"/><br>
<? showEnd (); ?>
</li>
</ol>
</li>
<li>
Run MySQL Workbench, open your localhost connection and select <b>Server Status</b> from the left menu.
<br>Take a screenshot of the MySQL Workbench window and save it as <b><?=$saveFilename?>-Workbench.png</b> in your <b><?=$evaluationName?></b> folder.
<? showBegin('See Workbench example screenshot'); ?><br>
<img src="Workbench.png" width="682" height="340" alt="Workbench example screenshot"/><br>
<? showEnd (); ?>
</li>
<li>Turn in your assignment:
<ol type="a">
<li>Zip up your <b><?=$evaluationName?></b> folder into a file named <b><?=$uploadFilename?></b>.</li>
<li>Browse and select your <b><?=$uploadFilename?></b> file: <input type="file" name="fileUpload" id="inpFileUpload"<?=$disabled?>><div id="divFileploadError"></div></li>
<li>Then <input type="submit" name="f_subtask" id="inpSubmit" value="Submit"<?=$disabled?>> for grading.</li>
</ol>
</li>
</ol><? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><br><? } ?>
</fieldset>
<?
require('Gradebook/EvaluationSubmission_END.phpinc'); // Replaced.
#require('../../ReferencesResources.phpinc');
#require('JimMartinson/ContactInformation.phpinc');
require('common/pageFooter.phpinc');
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>