| 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/CST1600/Labs/Lab01/ |
Upload File : |
<?
// MichaelMalz/CST1600/Labs/Lab01/index.php
$disabled = '';
#$disabled = ' disabled';
require('Gradebook/EvaluationSubmission_BEGIN.phpinc'); // Replaced.
#d_Var('$_SESSION',$_SESSION,'d');
$uploadFilename = $saveFilename.'.zip'
?>
<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 Community 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">
Create a directory for all work performed for this class.<br>
Create a directory called <b><?=$evaluationName?></b>. We will use it for all work performed in this lab.
<li>Install MySQL Community Server and MySQL Workbench.
<br>
<span id="spn_lin_3" class="hidden info">Instructions for <b>Linux</b> OS:</span>
<span id="spn_mac_3" class="hidden info">Instructions for <b>Mac</b> OS:</span>
<span id="spn_win_3" class="info">Instructions for <b>Windows</b> OS:</span>
<input id="inp_lin_3" type="button" onClick="return SwapWinMacLinux('lin',[3,4]);" value="Switch to Linux instructions">
<input id="inp_mac_3" type="button" onClick="return SwapWinMacLinux('mac',[3,4]);" value="Switch to Mac instructions">
<input id="inp_win_3" type="button" onClick="return SwapWinMacLinux('win',[3,4]);" value="Switch to Windows instructions" class="hidden">
<? /** / BEGIN WINDOWS INSTRUCTIONS /**/ ?>
<ol id="ol_win_3">
<li>
Download and install <b>MySQL Community Server and MySQL Workbench</b> for Windows <a href="../../Resources/Install/mysql-installer-community-8.0.41.0.msi">mysql-installer-community-8.0.41.0.msi</a>).
You can review the recording to see how.
You may need to download and install the <a href="https://cst.ridgewater.edu/MichaelMalz/CST1600/Resources/Install/2015-2022_VC_redist.x64.exe"> Microsoft C++ 2019 redistributable</a>.
</li>
<li>
Download <a href="../../../Setup/WebServices/WebServices.cmd">WebServices.cmd</a>, create a shortcut and set it to run as administrator.
</li>
<li>Run WebServices and ensure that you can start and stop MySQL Server. You may also want to set it to start manually.</li>
</ol>
<? /** / END WINDOWS INSTRUCTIONS /**/ ?>
<? /** / BEGIN MAC INSTRUCTIONS /**/ ?>
<ol id="ol_mac_3" class="hidden">
Most modern Mac systems come with MySQL Server already installed.
<br>If your system is one of those then you need only install MySQL Workbench.
<li>
If your Mac system does not have MySQL Server installed, download and install <b>MySQL Community Server and MySQL Workbench</b> for <span class="info">Mac</span> (<a href="../../Resources/Install/mysql-8.0.19-macos10.15-x86_64.dmg">mysql-8.0.19-macos10.15-x86_64.dmg</a>).
<br>Use the recording from <a href="https://minnstate.zoom.us/rec/share/ZAQbeJ7kL-nMtvaiFsJmlK1Q9UUeeO7htaQBb9sxj-vRgMz3UB_TcoxvEQedja1S.hIYuq6RAX_NDYW8H?startTime=1630433967000" target="_blank">Tuesday, 08/31</a> to view a <span class="info">Windows</span> install.
</li>
<li>Run MySQL Workbench and open your localhost connection and select <b>Startup / Shutdown</b> from the left menu and ensure you can start and stop the MySQL Server from Workbench.
<br><span class="note">macos10.15 can use the Workbench Startup/Shutdown controls. Other Mac systems have other methods to control the MySQL Server.</span>
</li>
</ol>
<? /** / END MAC INSTRUCTIONS /**/ ?>
<? /** / BEGIN Linux INSTRUCTIONS /**/ ?>
<ol id="ol_lin_3" class="hidden">
<li>
Download and install <b>MySQL Community Server and MySQL Workbench</b> for your version of <span class="info">Linux</span> from the <a href="https://dev.mysql.com/downloads/mysql/" target="_blank">MySQL Ccmmunity Downloads</a> page.
<br>Use the recording from <a href="https://minnstate.zoom.us/rec/share/ZAQbeJ7kL-nMtvaiFsJmlK1Q9UUeeO7htaQBb9sxj-vRgMz3UB_TcoxvEQedja1S.hIYuq6RAX_NDYW8H?startTime=1630433967000" target="_blank">Tuesday, 08/31</a> to view a <span class="info">Windows</span> install.
</li>
<li>Run MySQL Workbench and open your localhost connection and select <b>Startup / Shutdown</b> from the left menu and ensure you can start and stop the MySQL Server from Workbench.</li>
</ol>
<? /** / END Linux INSTRUCTIONS /**/ ?>
</li>
<li>
Run MySQL Workbench, open your localhost connection and select <b>Server Status</b> from the left menu.
<br>Ensure the server status is in the MySQL Workbench window and that the MySQL Server is running.
<br>Take a screenshot of MySQL Workbench and save it as <b class="copyText"><?=$saveFilename?>.png</b> in your <b><?=$evaluationName?></b> folder.
<? showBegin('See Workbench example screenshot'); ?><br>
<img src="Workbench.png" width="1000" height="522" alt="Workbench server status example screenshot"/><br>
<? showEnd (); ?>
<br>Note that all screenshots for this class must be saved in <a href="http://www.libpng.org/pub/png/">Portable Network Graphics</a> (.png) format.
<br>Screenshots must also be limited to what was requested. Do not submit entire screens as screenshots unless requested.
</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>Then attach this file to the assignment in D2L 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');
require('common/sectionFooter.phpinc');
?>
<script>
// SwapWinMacLinux(ShowOS,IdNumber)
// Swap between Windows, Mac, and Linux instructions. Will show ol and hide spn and inp elements for the ShowOS.
// ShowOS = the OS to show instructions for.
// IdNumber = the IdNumber of the instruction.
function SwapWinMacLinux(ShowOS,IdNumbers) {
console.warn('SwapWinMacLinux[ShowOS='+ShowOS+',IdNumbers='+IdNumbers+']');
console.log('IdNumbers='+IdNumbers+' typeof IdNumbers='+(typeof IdNumbers));
if ( typeof IdNumbers == 'number' ) { IdNumbers = [IdNumbers] ; } // Convert single IdNumbers to array.
var e;
var Element;
var ElementHides = ['inp']; // Hide these elements for ShowOS and show them for other OSes.
var ElementId;
var ElementShows = ['spn','ol']; // Show these elements for ShowOS and hide them for other OSes.
var ElementType;
var h;
var i;
var IdNumber;
var OtherOS;
var OtherOSes;
switch ( ShowOS ) {
case 'lin':
OtherOSes = ['mac','win'];
break;
case 'mac':
OtherOSes = ['lin','win'];
break;
case 'win':
OtherOSes = ['lin','mac'];
break;
}
console.log('OtherOSes='+OtherOSes);
for ( i=0; i<IdNumbers.length; i++ ) { // Loop thru IdNumbers.
IdNumber = IdNumbers[i];
// Hide ShowOS button.
console.warn('Hide ShowOS button.');
for ( e=0; e<ElementHides.length; e++ ) {
ElementType = ElementHides[e];
ElementId = ElementType+'_'+ShowOS+'_'+IdNumber;
console.log('Hide '+ElementId+'.');
Element = document.getElementById(ElementId);
if ( Element ) { // Does the ElementId element exist?
Element.style.display = 'none';
} // Does the ElementId element exist?
}
// Show other OS buttons.
console.warn('Show other OS buttons.');
for ( h=0; h<OtherOSes.length; h++ ) { // Loop thru OtherOSes.
OtherOS = OtherOSes[h];
for ( e=0; e<ElementHides.length; e++ ) {
ElementType = ElementHides[e];
ElementId = ElementType+'_'+OtherOS+'_'+IdNumber;
console.log('Show '+ElementId+'.');
Element = document.getElementById(ElementId);
if ( Element ) { // Does the ElementId element exist?
StyleDisplay = DisplayStyle(ElementType,Element);
Element.style.display = StyleDisplay;
console.log(ElementId+'.style.display='+StyleDisplay);
} // Does the ElementId element exist?
}
} // Loop thru OtherOSes.
// Hide other OS span and instructions.
console.warn('Hide other OS span and instructions.');
for ( h=0; h<OtherOSes.length; h++ ) { // Loop thru OtherOSes.
OtherOS = OtherOSes[h];
for ( e=0; e<ElementShows.length; e++ ) { // Loop thru ElementShows.
ElementType = ElementShows[e];
ElementId = ElementType+'_'+OtherOS+'_'+IdNumber;
Element = document.getElementById(ElementId);
console.log('Hide '+ElementId+'.');
if ( Element ) { // Does the ElementId element exist?
Element.style.display = 'none';
} // Does the ElementId element exist?
} // Loop thru ElementShows.
} // Loop thru OtherOSes.
// Show ShowOS span and instructions.
console.warn('Show ShowOS span and instructions.');
for ( e=0; e<ElementShows.length; e++ ) { // Loop thru ElementShows.
ElementType = ElementShows[e];
ElementId = ElementType+'_'+ShowOS+'_'+IdNumber;
console.log('Show '+ElementId+'.');
Element = document.getElementById(ElementId);
if ( Element ) { // Does the ElementId element exist?
StyleDisplay = DisplayStyle(ElementType,Element);
Element.style.display = StyleDisplay;
console.log(ElementId+'.style.display='+StyleDisplay);
} // Does the ElementId element exist?
} // Loop thru ElementShows.
} // Loop thru IdNumbers.
return false;
} // END SwapWinMacLinux.
// DisplayStyle(element)
function DisplayStyle(Type,Element) {
//console.warn('DisplayStyle[Type='+Type+',Element='+Element.id+']');
var StyleDisplay = Element.style.display;
//console.log('StyleDisplay='+StyleDisplay);
if ( StyleDisplay === '' || StyleDisplay === 'none' ) { // Is the StyleDisplay empty?
var StyleDisplays = { inp:'inline', ol:'block', spn:'inline' };
switch ( Type ) { // Switch Type.
case 'inp':
case 'ol':
case 'spn':
StyleDisplay = StyleDisplays[Type];
break;
default:
StyleDisplay = 'inline';
} // Switch Prefix.
//console.log('StyleDisplay='+StyleDisplay);
}
return StyleDisplay;
}
</script>
<?
#require('../../ReferencesResources.phpinc');
#require($Instructor['Path'].'/ContactInformation.phpinc');
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>