Home | Troubleshooting |  Quick Setup  |  Cisco How to  |  Data Recovery  |  Forums   | Blog | IT Exam Practice | Services  | About Us | Chicagotech MVP  | Search  | Contact Us  |                 

 

 

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


 

 


 

 

Hit Counter   This web is provided "AS IS" with no warranties.
Copyright © 2002-2018 ChicagoTech.net, All rights reserved. Unauthorized reproduction forbidden.