Page 8 - Payout Magazine Online Volume 9.4

MySQL
Step-By-Step
Installation Guide
MySQL is the most popular open source
database being used today. In addition
to its fast database engine, it’s easy to set up,
simple to use, and well-integrated with PHP,
making it a great candidate for a variety of web
applications.
While there are versions of MySQL available
for Mac, Linux, and a number of other operating
systems, Windows remains the most popular
OS for a variety of reasons. Today, we’ll have a
step-by-step look at how to easily install MySQL
on Windows both manually and by using the
MySQL installer.
Manually Install MySQL
The MySQL Installation Wizard and many all-
in-one Windows packages can make installing
MySQL a quick and easy process. However,
manually installing MySQL will provide you with
more control and allow you to learn much more
about the system.
� Step 1 - Download MySQL
The first step in manually installing MySQL is from the C:mysqldata folder into it.
to download it from dev.mysql.com/downloads/.
8 PayOutMagazine
Go to the MySQL Community Server, select
Windows, and download the version labeled
Without installer.
As is good practice, scan the file for viruses
and use a tool to check the MD5 checksum
prior to download.
� Step 2 - Extract the Files
Extract the file to your C: drive and change
the folder name from “mysql-x.x.xx-win32” to
simply “C:mysql”.
You can install MySQL anywhere on your
Windows system. If you would prefer a lighter
installation, all of the sub-folders except for
scripts, data, share, and bin can be removed.
� Step 3 - Move the Folder
While this step is optional, it is a good
idea to move the data folder to another drive
or a partition in order to make re-installation
and backups easier. To do so, create a
D:MySQLdata folder and transfer the data
Now, you should have two folders:
D:MySQLdatatest and D:MySQLdatamysql.
You can remove the original C:mysqldata
folder.
� Step 4 - Create a my.ini Configuration File
There are several configuration methods
for MySQL, but creating a my.ini file within the
mysql folder is generally the easiest. While
you can tweak MySQL hundreds of different
ways to meet your exact requirements, the
most basic and simple my.ini file is:
• [mysqld]# installation
directorybasedir=”C:/mysql/”# data
directorydatadir=”D:/MySQLdata/”
� Step 5 - Test the Installation
Runnning C:mysqlbinmysqld.exe will start
the MySQL server. You will also need to open
a command box and enter these commands:
• cd mysqlbinmysqld
This command will run the MySQL server,
which will listen for requests via localhost port