Computersnyou

How To Install MySQL On Windows (8)

Posted on  9/10/2012
<p>
  MySQL is well known free and open source Robust database . in this guide i will show you how to and where from download MySQL and install it in windows with some other helping apps . so you can easily start with MySQL
</p>

<p>
  1 :  Download MySQL <a href="http://dev.mysql.com/downloads/">http://dev.mysql.com/downloads/</a><br /> now you have two option either download all in one package or single community server and other tools separately
</p>
Download Full Installer ( if you have good internet connection )

download http://dev.mysql.com/downloads/installer/or if you have slow internet connection download MySQL community server only and download MySQL workbench separately

<p>
  download MySQL community server  <a href="http://dev.mysql.com/downloads/mysql/">http://dev.mysql.com/downloads/mysql/</a><br /> download MySQL  workbench ( GUI tool )  <a href="http://dev.mysql.com/downloads/workbench/5.2.html">http://dev.mysql.com/downloads/workbench/5.2.html</a>
</p>

<p>
  2 : Install MySQL
</p>

<ul style="text-align: left;">
  <li>
    Install normally ( Like other appications , next next next :p )
  </li>
  <li>
    after installation finish it will open configuration wizard
  </li>
</ul>

<div style="text-align: center;">
  <a style="margin-left: 1em; margin-right: 1em;" href="http://4.bp.blogspot.com/-EAS1oqCifwg/UE4XxAhn6CI/AAAAAAAAG2o/Jy8zPB-RWZM/s1600/mysql_config_1.png"><img class="aligncenter" src="http://4.bp.blogspot.com/-EAS1oqCifwg/UE4XxAhn6CI/AAAAAAAAG2o/Jy8zPB-RWZM/s1600/mysql_config_1.png" border="0" /></a>
</div>

<div class="separator" style="clear: both; text-align: center;">
  <a style="margin-left: 1em; margin-right: 1em;" href="http://2.bp.blogspot.com/-55qIDbWuj-s/UE4XoJTITWI/AAAAAAAAG10/ZTti7XoK1ok/s1600/mysql_1.png"><img class="aligncenter" src="http://2.bp.blogspot.com/-55qIDbWuj-s/UE4XoJTITWI/AAAAAAAAG10/ZTti7XoK1ok/s1600/mysql_1.png" border="0" /></a>
</div>

<div class="separator" style="clear: both; text-align: center;">
  <a style="margin-left: 1em; margin-right: 1em;" href="http://3.bp.blogspot.com/--EJ3yWJ3mL0/UE4XpkeBx2I/AAAAAAAAG2A/zgZAPc_mVVs/s1600/mysql_2.png"><img class="aligncenter" src="http://3.bp.blogspot.com/--EJ3yWJ3mL0/UE4XpkeBx2I/AAAAAAAAG2A/zgZAPc_mVVs/s1600/mysql_2.png" border="0" /></a>
</div>

<table class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td style="text-align: center;">
      <a style="margin-left: auto; margin-right: auto;" href="http://3.bp.blogspot.com/-ajTrzu8_KeE/UE4XrNT9GkI/AAAAAAAAG2I/fOSIcM1KmLg/s1600/mysql_3.png"><img class="aligncenter" src="http://3.bp.blogspot.com/-ajTrzu8_KeE/UE4XrNT9GkI/AAAAAAAAG2I/fOSIcM1KmLg/s1600/mysql_3.png" border="0" /></a>
    </td>
  </tr>
  
  <tr>
    <td class="tr-caption" style="text-align: center;">
      make sure you checked that in order to run mysql from command line
    </td>
  </tr>
</table>

<table class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td style="text-align: center;">
      <a style="margin-left: auto; margin-right: auto;" href="http://2.bp.blogspot.com/-1jSCL8-ofGM/UE4XsVjYv2I/AAAAAAAAG2Q/n1R7zq5llPg/s1600/mysql_4.png"><img class="aligncenter" src="http://2.bp.blogspot.com/-1jSCL8-ofGM/UE4XsVjYv2I/AAAAAAAAG2Q/n1R7zq5llPg/s1600/mysql_4.png" border="0" /></a>
    </td>
  </tr>
  
  <tr>
    <td class="tr-caption" style="text-align: center;">
      if you are installing on local development machine then don&#8217;t check enable root access
    </td>
  </tr>
</table>

<div class="separator" style="clear: both; text-align: center;">
  <a style="margin-left: 1em; margin-right: 1em;" href="http://4.bp.blogspot.com/-EAS1oqCifwg/UE4XxAhn6CI/AAAAAAAAG2o/Jy8zPB-RWZM/s1600/mysql_config_1.png"> </a>
</div>

<table class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td style="text-align: center;">
      <a style="margin-left: auto; margin-right: auto;" href="http://2.bp.blogspot.com/-1dl2Hq6HGHg/UE4Xt4nojVI/AAAAAAAAG2Y/aWy3RT6RA34/s1600/mysql_5.png"><img class="aligncenter" src="http://2.bp.blogspot.com/-1dl2Hq6HGHg/UE4Xt4nojVI/AAAAAAAAG2Y/aWy3RT6RA34/s1600/mysql_5.png" border="0" /></a>
    </td>
  </tr>
  
  <tr>
    <td class="tr-caption" style="text-align: center;">
      Clickk on Finish
    </td>
  </tr>
</table>

<p>
  Now open CMD and type
</p>

<pre class="codesBash">mysql -u root -p</pre>

<div class="separator" style="clear: both; text-align: center;">
  <a style="margin-left: 1em; margin-right: 1em;" href="http://3.bp.blogspot.com/--CKa0C-MauE/UE4Xmc9WlNI/AAAAAAAAG1w/t02EEYgPS0o/s1600/cmd_mysql.png"><img class="aligncenter" src="http://3.bp.blogspot.com/--CKa0C-MauE/UE4Xmc9WlNI/AAAAAAAAG1w/t02EEYgPS0o/s640/cmd_mysql.png" width="640" height="393" border="0" /></a>
</div>

<table class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td style="text-align: center;">
      <a style="margin-left: auto; margin-right: auto;" href="http://4.bp.blogspot.com/-H2fHcK9ykp8/UE4XvF54uQI/AAAAAAAAG2g/d2jR0p-zxJY/s1600/mysql_7.png"><img class="aligncenter" src="http://4.bp.blogspot.com/-H2fHcK9ykp8/UE4XvF54uQI/AAAAAAAAG2g/d2jR0p-zxJY/s640/mysql_7.png" width="640" height="369" border="0" /></a>
    </td>
  </tr>
  
  <tr>
    <td class="tr-caption" style="text-align: center;">
      MySQL command line interface
    </td>
    
    <td class="tr-caption" style="text-align: center;">
    </td>
    
    <td class="tr-caption" style="text-align: center;">
    </td>
    
    <td class="tr-caption" style="text-align: center;">
    </td>
    
    <td class="tr-caption" style="text-align: center;">
    </td>
  </tr>
</table>

<p>
  OR you can download MySQL workbench , which is a GUI application with lots of features .
</p>

<table class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td style="text-align: center;">
      <a style="margin-left: auto; margin-right: auto;" href="http://4.bp.blogspot.com/-crZYgl_PuDA/UE4Z6vc5FpI/AAAAAAAAG24/1jWAOOJ7OQY/s1600/wb_admin.png"><img class="aligncenter" src="http://4.bp.blogspot.com/-crZYgl_PuDA/UE4Z6vc5FpI/AAAAAAAAG24/1jWAOOJ7OQY/s640/wb_admin.png" width="640" height="360" border="0" /></a>
    </td>
  </tr>
  
  <tr>
    <td class="tr-caption" style="text-align: center;">
      MySQL workbench admin panel
    </td>
  </tr>
</table>

  • Home
  • About