how to install mysql on windows


Installing MySQL on Mac OS X

The MySQL installation process for Mac OS X is fairly straightforward—there is an installation package for Mac OS X. Go to the MySQL downloads page at and select Mac OS X from thedrop-down list . If you are going to the website, be sure to download the appropriate DMG archive for your system: either 10.5 or 10.6, and either 32- or 64-bit.
Procedures and steps you would know yourself when you download and install in in your machine.

How to install mysql on windows

Installing MySQL on Windows

The MySQL installation process on Windows uses a standard Microsoft Windows Installer (MSI) file to walk you through the installation and configuration of MySQL on your Windows XP, Windows Server 2003, Windows Vista, or Windows 7 machine. Go to the MySQL downloads page at 5.5.html and select the Windows option from the drop-down menu. Download the Windows MSI Installer file for your system, either 32- or 64-bit.

follow this below screen as you are installing mysql manually.

The next configuration option pertains to database usage. The options are
Multifunctional Database, for both InnoDB and MyISAM storage engines,
with resources split evenly between the two; Transactional Database, which
enables both InnoDB and MyISAM, but dedicates the most server resources to
InnoDB; and Non-Transactional Database Only, which disables InnoDB and
applies all resources to MyISAM. Unless you know exactly what your database
will be used for, select the Multifunctional Database radio button and click
Next to continue.

The next configuration option determines the number of concurrent connections
to your MySQL server. Your setting will depend on the amount of traffic
and database usage by your website or application. The default setting is
Decision Support (DSS)/OLAP, which has a maximum number of 100 concurrent
connections with an average of 20 assumed. The Online Transaction
Processing (OLTP) option has a maximum of 500 concurrent connections, and
the Manual setting allows you to select a number from a drop-down list or
enter your own. Make your selection and click Next to continue.
10. The Networking Options screen is next in the configuration sequence. Here
you enable or disable TCP/IP networking and configure the port number used
to connect to MySQL—the default is 3306, but you can use any unused port
you choose. The other option on this screen is to enable or disable strict mode;
enabling strict mode is recommended unless you know what you’re changing.
See for more
information. Make your selections and click Next to continue.
throughout your database. You can also select the Best Support for
Multilingualism option, which results in UTF8 as the character set; UTF8
allows you to store multiple languages in a single character set. If you want to
use a specific character set, select the Manual Selected Default Character Set
radio button, and then select the appropriate character set from the dropdown
list. After making your selection, click Next to continue.
12. It is recommended that MySQL be installed as a service. Check the Install as
Windows Service check box and select a name for the service. Optionally,
check the Launch the MySQL Server Automatically check box. You also have
the option of adding the MySQL bin directory to your Windows PATH for easier
invocation of MySQL from the cmd prompt; check the box if this is appropriate
for you. When you have completed your selections, click Next to continue.
13. The Security Options configuration screen is the most important screen of all.
As shown in Figure 2.10, use this configuration screen to set a root password.
Enter the password twice to confirm it. Do not check the Enable Root Access
from Remote Machines check box unless you really know what you’re doing;
typically, root connections are allowed only from localhost. In addition, you
can create an anonymous account, but doing so is not recommended for security
reasons. After completing the configuration options in this screen, click
Next to continue.


Leave A Reply

Your email address will not be published.