ÿþ<HTML><HEAD><TITLE>DigitalScores</TITLE> <META content="digital scores, software, programming, australia, java programmer, java development, java developer, java database" name=keywords> <META content="DigitalScores. Reliable Software Development." name=description> <STYLE type=text/css>@import url( http://www.digitalscores.com/DS_LAF/main.css ); </STYLE> </HEAD> <BODY bgColor=#ffffff leftMargin=0 topMargin=0 marginwidth="0" marginheight="0"> <TABLE style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px" cellSpacing=0 cellPadding=0 width=790 border=0> <TBODY> <TR> <TD width=10 rowSpan=6><IMG height=1 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=10 border=0></TD> <TD colSpan=4> <DIV class=toolbar> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD colSpan=8></TD></TR> <FORM method=GET action="http://www.google.com/search"> <TR> <TD vAlign=center noWrap width="100%"> <DIV class=sitelinks><A id=homelink href="http://www.digitalscores.com/">DigitalScores.com</A> </DIV></TD> <TD vAlign=center noWrap> <DIV class=sitelinks><A href="http://www.digitalscores.com/support.html">Support </A>&nbsp;&nbsp;|&nbsp;&nbsp;<A href="http://www.digitalscores.com/downloads.html">Download </A>&nbsp;&nbsp;</DIV></TD> <TD noWrap>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD> <TD><LABEL for=searchfield><IMG height=1 alt=Search src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=1 border=0></LABEL></TD> <TD vAlign=center> <INPUT class=medium TYPE=text name=q size=45 maxlength=255 onfocus="if( this.value=='Search' ) this.value='site:www.digitalscores.com ';" size=10 value='Search'> </TD> <TD>&nbsp;&nbsp;</TD> <TD vAlign=center align=left><INPUT class=buttonred name=btnG id=searchbttn onmouseover="this.style.color='#FFFFAA';" onmouseout="this.style.color='#FFF';" type=submit value=&nbsp;&gt;&nbsp; border=0></TD> <TD>&nbsp;</TD></TR> </FORM> <TR> <TD colSpan=7></TD> <TD><LABEL for=searchbttn><IMG height=2 alt="Submit Search" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=10 border=0></LABEL></TD></TR></TBODY></TABLE><!-- END GLOBAL NAVIGATION TOOLBAR --></DIV></TD></TR><!-- BEGIN MASTHEAD --> <TR> <TD vAlign=top width=170 bgColor=#e25c6d height=87><IMG alt="DigitalScores Logo" src="http://www.digitalscores.com/DS_LAF/dslogo.gif" border=0></TD> <TD width=10 rowSpan=2><IMG height=1 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=10 border=0></TD> <TD vAlign=bottom width=590 bgColor=#999999> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD vAlign=bottom><font face=arial size=2 color=ffffff>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Featured article&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></TD></TR> <TR> <TD vAlign=bottom><!-- BEGIN OVERLAP OR SPACER IMG --> <DIV><IMG height=30 alt=" " src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=1 border=0></DIV><!-- END OVERLAP OR SPACER IMG --></TD></TR></TBODY></TABLE></TD> <TD width=10 rowSpan=5><A name=mast></A><IMG height=1 src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=10 border=0></TD></TR><!-- END MASTHEAD --> <TR vAlign=top> <TD> <DIV class=homenav><!-- BEGIN NAV MENU --> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR vAlign=top> <TD class=htitle> <DIV>On DigitalScores</DIV></TD></TR> <TR vAlign=top> <TD class=hitemtop> <DIV><A href="http://www.digitalscores.com/services.html">Products &amp; Services</A></DIV></TD></TR> <TR vAlign=top> <TD class=hitem> <DIV><A href="http://www.digitalscores.com/support.html">Support </A></DIV></TD></TR> <TR vAlign=top> <TD class=hitem> <DIV><A href="http://www.digitalscores.com/downloads.html">Download library </A></DIV></TD></TR> <TR vAlign=top> <TD class=htitle> <DIV>Resources for</DIV></TD></TR> <TR vAlign=top> <TD class=hitemtop> <DIV><A href="http://www.digitalscores.com/developers.html">Developers</A></DIV></TD></TR> <TR vAlign=top> <TD class=hitem> <DIV><A href="http://www.digitalscores.com/press.html">Press</A></DIV></TD></TR> <TR vAlign=top> <TD class=htitle> <DIV>Explore</DIV></TD></TR> <TR vAlign=top> <TD class=hitemtop> <DIV><A href="http://www.digitalscores.com/featured-articles/03/webservices.html">Web services</A></DIV></TD></TR> <TR vAlign=top> <TD class=hitem> <DIV><A href="http://www.digitalscores.com/jcdatabase">JCDatabase</A></DIV></TD></TR> <TR vAlign=top> <TD class=hitem> <DIV><A href="http://www.digitalscores.com/3dmatrix">3DMatrix</A></DIV></TD></TR> </TR> </table> </div> <a name="skip2content"></a> </td> <td> <!-- Spacer lines --> <table cellspacing=0 cellpadding=0 width=100% border=0> <tr><td bgColor=#ffffff><IMG height=8 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=170 border=0></td></tr> <tr><td bgColor=#cccccc><IMG height=4 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=170 border=0></td></tr> <tr><td bgColor=#ffffff><IMG height=6 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=170 border=0></td></tr> </table> <big>Stopping and Starting MySQL with Windows</big><p> <P>This article may help you to get starting in using MySQL under NT. There is no distinction made between Windows NT, Windows 2000 or Windows XP. These three operating systems support 'Windows services' which you will not find with the Windows 95/98/ME versions.</P> <P>If you haven't already installed MySQL you can do so by visiting <A HREF="http://www.mysql.com/">www.mysql.com</A> and following the download instructions. There is nothing spectacular to see when installing MySQL - as far as I know it just dumps the collection of files and directories into the c:\mysql directory and you need to visit the c:\mysql\bin and list the .exe files to see what is available. </P> <P>To get started you can play with MySQL by typing: </P> <P><CODE>c:\mysql\bin&gt;mysqld-nt --install<BR>c:\mysql\bin&gt;mysql </CODE> </P> <P>You will then have a command line where you can enter SQL statements ending with a semicolon and the other commands can be found by typing 'help'. You can exit by typing 'exit'. </P> <P>MySQL is designed to run in the background without ever stopping, even resuming after rebooting Windows. To control Windows services you can use Window's 'net' command. For example, to list all services currently installed just type: </P> <P><CODE>c:\mysql\bin&gt;net start </CODE> </P> <P>You will see MySQL listed as one of the services and if you reboot NT this service will continue. To stop the service you need to type the following two commands in the correct order: </P> <P><CODE>c:\mysql\bin&gt;net stop MySql<BR>c:\mysql\bin&gt;mysql-nt --remove </CODE> </P> <P>You might now wish to start a different version of MySQL, such as mysql-max-nt which adds support for foreign key constraints among other things, by typing the following commands: </P> <P><CODE>c:\mysql\bin&gt;mysql-max-nt --install<BR>c:\mysql\bin&gt;net start MySql </CODE> </P> <P>Now that you know the basics you can return to <A HREF="http://www.mysql.com/">www.mysql.com</A> to learn how to start building tables using MySQL's syntax nuances, connect your application to MySQL and learn why this open source database is so popular.</P> <small> Julian Cochran<br> DigitalScores<br></small> <a href=http://www.digitalscores.com>www.digitalscores.com</a><br> <DIV align=right style="PADDING-RIGHT: 0px; PADDING-LEFT: 12px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"><A href="http://www.digitalscores.com/featured-articles/all-features.html">return to all features »</A></DIV> </td> </TR><!-- BEGIN FOOTER --> <TR> <TD colSpan=3><IMG height=9 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=1 border=0></TD></TR> <TR> <TD bgColor=#cccccc><IMG height=4 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=170 border=0></TD> <TD rowSpan=2>&nbsp;</TD> <TD bgColor=#cccccc><IMG height=4 alt="" src="http://www.digitalscores.com/DS_LAF/pixel.gif" width=1 border=0></TD></TR> <TR vAlign=top> <TD> <DIV class=footlinks>© DigitalScores 2003 </DIV></TD> <TD> <DIV class=footlinks><A href="http://www.digitalscores.com/contact.html">Contact</A>&nbsp;| <A href="http://www.digitalscores.com/company-information.html">Company Info</A>&nbsp;| <A href="http://www.digitalscores.com/employment.html">Employment</A>&nbsp;| <A href="http://www.digitalscores.com/privacy.html">Privacy</A>&nbsp;| <A href="http://www.digitalscores.com/terms-of-use.html">Terms of Use</A> </DIV></TD></TR><!-- END FOOTER --></TBODY></TABLE></BODY></HTML>