How to run
MySQL Server Instance
Configuration Wizard - Part 1
6. The Concurrent Connections selection prevents the server from
running out of resources. It is important to limit the number of concurrent
connections to the MySQL server
that can be established.
1) Decision Support (DSS)/OLAP: Choose this option if your server does not
require a large number of concurrent connections. The maximum number of
connections is set at 100, with an average of 20 concurrent connections
assumed.
2) Online Transaction Processing (OLTP): Choose this option if your server
requires a large number of concurrent connections. The maximum number of
connections is set at 500.
3) Manual Setting: Choose this option to set the maximum number of
concurrent connections to the server manually. Choose the number of
concurrent connections from the drop-down box provided, or enter the maximum
number of connections into the drop-down box if the number you desire is not
listed.
7. T\In the Networking and Strict Mode Options Dialog, enable the
TCP/IP networking and add port 3306 to the windows firewall for remote
access. Enabling strict mode (default) makes MySQL behave more like
other database management systems.
If the port 3306 is not open or you incorrect security settings, you
may receive the error 1364 as shown below.
8. There are 3 options in the Character Set Dialog:
1) Standard Character Set: Choose this option if you want to use latin1 as
the default server character set. latin1 is used for English
and many Western European languages.
2) Best Support For Multilingualism: Choose this option if you want to use
utf8 as the default server character set. This is a Unicode
character set that can store characters from many different languages.
3) Manual Selected Default Character Set / Collation: Choose this option if
you want to pick the server's default character set manually.
Choose the desired character set from the provided drop-down list.
9. The MySQL Server Instance Configuration Wizard installs the MySQL
server as a service by default, using the service name MySQL.
10. There are two options in the Security Options Dialog
1) Setting the root password for a new installation.
2) To set the root password, enter the desired password into both the New
root password and Confirm boxes.
11. The final dialog in the MySQL Server Instance Configuration Wizard
is the CONFIRMATION DIALOG. To start the configuration process, click the
EXECUTE button. If not errors, you will see the successful complete installation
windows. Click Finish to close the windows.
Previous
Post your questions, comments, feedbacks and suggestions
Contact a consultant
Related Topics
|