Install MySQL on windows 8 – create your own server – part 3
This is the third tutorial in the series of three tutorials on how to create your own server. In this tutorial, we will be showing you how to install MySQL on your system. For this tutorial we will install MySQL on windows 8 system. For other operating systems the instructions would be similar.
Step 1: Downloading MySQL
Before starting with download first make sure which version of windows are you using (64 bit or 32 bit). To know about your system details just open Run (windows key + R) and type “dxdiag.exe” (without quotes) and press enter. There you will get complete information about your system.
Now go to http://www.mysql.com/downloads/mysql/ and select Microsoft Windows from the dropdown. Then download the msi installer for your system type (32 or 64 bit) (if you have 64 bit OS then download 64 bit msi installer only).
Step 2: Install MySQL
a) Now go to your downloads folder (where you have download the mysql file) and double click on the file to run it.
b) On the next screen accept the licence agreement.
c) Choose Custom installation on next screen ( if you want you can choose typical, that will install mySQL in program files)
d) For custom installation, Change the MySQL installation path to C:ServerMySQL
e) Now click on Install button to begin the MySQL installation process.
f) When the installation finishes it will prompt you to Launch the MySQL instance configuration Wizard. Allow it to launch the configuraton wizard and click on finish.
Step 3: Configuring MySQL Instance
a) First it will ask for detailed or standard configuration. Select Detailed Configuration.
b) On the next screen, select developer Machine
c) Next select Multifunctional Database
d) On next screen, keep the default values.
e) Next select decision support
f) Next enable TCP/IP network, enable strict mode and also add firewall exception.
g) Next select Standard Character set
h) Enable both install as windows service and add bin directory to windows path
i) Now enter the password for MySQL twice and remember it (better note it down somewhere)
j) Finally click next and Execute and it will begin its execution. The process will take some time. During the process, the wizard may not respond for a while. It is normal.
Step 4: Configuring PHP to work with MySQL
Open php.ini file from the PHP installation folder (where you have installed or extracted php files, for example, “C:ServerPHP”).
Find the Dynamic Extensions in that and scroll down. Remove semicolon before these two lines
Save your php.ini file and restart your apache server.
Step 5: Testing
To test if MySQL is working properly or not, go to your programs and open MySQL command line client. It will ask you for the password. Enter the password that you have set in the installation wizard. Next type this command to show all databases.
Don’t forget to put semicolon in the end of the statement.
Now if it shows you the results then you have successfully installed MySQL on your system.