Tuesday, October 4, 2016

MySql 5.5.16 Database Installation

Download MySQL installer file
  1. Download mysql-5.5.16-winx64.msi from this webpage link http://www.mysql.com/downloads/mysql/
  2. You will be asked to register or sign in at your account. Registering has its benefits, but if you are in a hurry, simply click on the No thanks, just start my downloads! Link.
  3. A list of sites from where you can download the MySQL file will be displayed.
  4. Choose a ‘mirror’ which is closest to your geographical location to get the file fast. FYI, there is no problem in choosing a site located in Europe even though you are in the United States

Setting up MySQL

  1. Move to the folder to which the MSI file was downloaded and double-click on it to start MySQL installation – click “Run” when prompted.Double-click on the MySQL installer (.msi) file. Choose Run when prompted.
  1. Click “Next” button in the introductory window
C:\Users\SSS2015052\Desktop\Mysql\1.png
  1. Accept the terms in the License Agreement by checking the box and hit “Next”
C:\Users\SSS2015052\Desktop\Mysql\2.png
  1. In the following screen, select Custom installation which will allow you to specify the folder to which MySQL will be installed. FYI, choosing Typical will put MySQL deep down in the “Program Files” folder.
  1. Click the “Browse” button
  1. And enter C:\MySQL in the Folder name field. Hit “OK” when done.
  1. The installer will change the MySQL installation folder to the one specified by you – C:\MySQL
  1. You are now ready to install MySQL on Windows 7 operating system. Click “Install”
  1. It would take some time for the progress bar to start moving… be patient.
C:\Users\SSS2015052\Desktop\Mysql\4.png
C:\Users\SSS2015052\Desktop\Mysql\5.png
C:\Users\SSS2015052\Desktop\Mysql\6.png
  1. You may also get messages along the way – simply click on “Next” to proceed.
  1. When the process finishes, you’ll get to see the final screen. Congratulations – MySQL has been installed on your computer. You are now prompted to Configure the MySQL server; click “Finish.

Configuring a MySQL instance

  1. The MySQL Instance Configuration Wizard will now launch click “Next” to proceed. Please note that you cannot use MySQL until an instance has been configured, so these steps are quite important.
C:\Users\SSS2015052\Desktop\Mysql\11.png
  1. Select “Detailed Configuration” option
C:\Users\SSS2015052\Desktop\Mysql\12.png
  1. Choose “Developer Machine
C:\Users\SSS2015052\Desktop\Mysql\13.png
  1. I suggest going ahead with “Multifunctional Database” unless you know what you are doing.
C:\Users\SSS2015052\Desktop\Mysql\14.png
  1. In the following screen, don’t mess with the default values and click “Next”.
C:\Users\SSS2015052\Desktop\Mysql\15.png
  1. The same goes for the subsequent screen; click “Next”
C:\Users\SSS2015052\Desktop\Mysql\16.png
  1. For the networking options configuration, put a check mark in front of “Enable Strict Mode” if it’s not there
C:\Users\SSS2015052\Desktop\Mysql\17.png

  1. Move ahead with the “Standard Character Set” C:\Users\SSS2015052\Desktop\Mysql\18.png

  1. Yes, it’s recommended to install MySQL as a Windows service and have the system include the MySQL bin directory in the Windows PATH variable.
C:\Users\SSS2015052\Desktop\Mysql\19.png
  1. The password for the MySQL server instance has to be typed in twice as below. Remember to keep a note of it and don’t lose it. The password doesn’t have to be very strong because, I suppose, you would be using MySQL on your computer for learning/development and NOT production.    
      
  1. The configuration wizard has received all the information it needs and is ready to create a MySQL server instance. Click “Execute” button
Instance Configuration Wizard is ready with all information - Click Execute button. MySQL instance configured successfully - click Finish.
Ignore messages from the anti-virus program and answer in the affirmative when the Windows 7 UAC (User Account Control) asks whether you want to run MySQLInstanceConfig.exe file. Generally, the instance should be configured without any problem.
However, if the MySQL Instance Configuration Wizard becomes unresponsive (the window shows a ‘Not Responding’ message), launch the Task Manager either from the Control Panel or use the old Ctrl-Alt-Del key combination and kill the program. Now go to C:\MySQL\bin folder and double click on MySQLInstanceCOnfig.exe file to launch the wizard once again.

Checking the MySQL installation

  1. The easiest way to check MySQL installation and confirm that it’s working properly is to use the MySQL Command Line Client. Fire it up from “All Programs” -> “MySQL” -> “MySQL Server 5.5“
  1. Now enter the MySQL password – the characters you type will be replaced by the asterisk sign (the password is not shown for security reasons – obviously)
  1. The MySQL client displays the mysql> prompt on successful login.


  1. Type show databases; (the semi-colon at the end is not a typo) and hit the enter key. This simple SQL command instructs MySQL to display the names of the installed databases and there should be four of these. Hurray! Rejoice because you have been able to correctly install MySQL on Windows 7.


3 comments:

  1. Thanks for sharing your knowledge with us. Your blog keeps getting better and better! You have a lot creativity and originality now keep it up! Maybe someday my website will be the same like yours :)

    ReplyDelete
  2. Thank you for your guide to with upgrade information about Tableau
    Tableau Online Training

    ReplyDelete