Installing & Configuring MySql for Windows

To install & configure MySql for Windows follow the step-by-step process below:-

1. Download MySql for windows:-

MySql is available in two Editions

1. Enterprise edition. (Paid version)
2. Community edition. (Free version)

To download the latest version of MySql go to www.mysql.com/downloads/installer
Click on the Download button to download .msi file.

2. Configure MySql for Windows.

After downloading MySql the next step is to Install the MySql on your system.

1. Unzip the mysql-5.5.xx-win32.zip file you just downloaded.

2. Double click on the mysql-5.5.xx-win32.msi file to start installation of MySql.

3. Read the welcome prompt & click Next.

4. Choose between a Typical, Complete, or Custom installation. The Typical
installation provides everything you need to effectively run MySQL, while the
Complete installation installs all the optional components in addition to the
documentation. The Custom installation allows you to wield total control over
what’s installed, in addition to allowing you to choose the installation
directory. Go ahead and choose the Custom installation and click Next.

5. At the top of the Custom Setup screen you’ll be able to determine which
features are installed. I suggest leaving this untouched; however, at the bottom
of the screen you’ll be able to change MySQL’s installation location. The
default is C:\Program Files\MySQL\MySQL Server 5.1. I suggest changing this
to C:\mysql. Click Next, and then click Install in the next window.

6. The installation process begins. Be patient while the process completes.

7. The next two screens contain advertisements. Feel free to click More… on either
of these screens to learn more about the respective offerings, or click Next to
continue the process.

8. The installation process is now complete. You are prompted to configure
MySQL. There’s no time like the present, so make sure this checkbox is
selected and then click Finish.


Configuring MySql for Windows:

1. You are first prompted to choose between Standard Configuration and
Detailed Configuration. Choosing Standard Configuration creates a general purpose
configuration that you can later adjust as necessary. For the purposes
of learning more about what configuration capabilities are at your immediate
disposal, choose Detailed Configuration and click Next.

2. Next, you’ll be asked to identify whether the MySQL server will be used for
development purposes, as a multiuse machine (web and database, for
instance), or as a dedicated MySQL machine. Your choice determines how
much memory will be consumed by MySQL. Choose the server type that suits
your present needs best and click Next.

3. Next, you’ll be prompted for the database configuration that best suits your
needs. For the purposes of this book, you need to choose Multifunctional
Database. The reason for the other two usage types, Transactional Database
Only and Non-Transactional Database Only, will become more apparent as
you learn more about MySQL in later chapters. Choose Multifunctional
Database, click Next, and then accept the InnoDB Tablespace Settings
presented in the next screen by again clicking Next.

4. Next, you’ll be prompted to configure the number of concurrent connections
estimated for the server. You have three options: Decision Support
(DSS)/OLAP, which is intended for a minimal number of concurrent
connections (fewer than 20), such as a small office setting; Online Transaction
Processing (OLTP), which is intended for high-traffic servers such a web server;
or set your own estimated number of connections. After you make your choice,
click Next.

5. Next, you’ll be prompted to determine whether TCP/IP networking should be
enabled and to confirm the default connection port 3306. The port should be
left as set, and TCP/IP networking should be left enabled if you intend to
connect to this server remotely. If all connections will be made locally, disable
this feature. You’ll also be asked whether to enable MySQL’s Strict Mode,
which will cause MySQL to conform with norms found in many other
enterprise databases. You should leave this enabled. Click Next to continue.

6. Next, you’ll be asked to determine which character set the MySQL server
should use. You have three options: Standard Character Set, which is best
suited for English and other Western European languages; Best Support for
Multilingualism, which uses the UTF-8 character set, capable of managing text in a wide
variety of languages; or manually select the character set of your
choosing. After you make your choice, click Next.

7. Next, you’ll be prompted to determine whether MySQL should be installed as a
Windows service, meaning it can be started automatically at system startup,
and shut down at system shutdown or reboot. If this will be a server, or if you
plan to regularly develop with the machine, consider installing it as a Windows
service and enabling the checkbox for starting MySQL automatically.
Additionally, you can add MySQL’s bin directory to the Windows path,
meaning you’ll be able to access any of MySQL’s utilities from the command
line without having to be in the bin directory. These tools are discussed in
further detail in Chapter 28. Enabling both of these options is recommended.
Once you’re done, click Next.

8. In the final configuration window, you’ll be prompted to choose and confirm a
root password. Take care to choose a secure password, but make sure it isn’t
something you’ll forget! You can also choose to enable root access from
remote machines, a feature that is not recommended if you don’t plan to allow
remote connections to this database. You can also choose to create an
anonymous account, something that isn’t recommended under any
circumstances. Click Next, and in the next window, start the configuration
process by clicking Execute. Once the process is complete, click Finish.

Now you are ready to use user MySql RDBMS. Read next post to Learn for How to use MySql.