From: mcbrown
Date: October 30 2006 4:34pm
Subject: svn commit - mysqldoc@docsrva: r3799 - trunk/refman-5.0
List-Archive: http://lists.mysql.com/commits/14573
Message-Id: <200610301634.k9UGYFDv028025@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: mcbrown
Date: 2006-10-30 17:34:12 +0100 (Mon, 30 Oct 2006)
New Revision: 3799
Log:
Split windows-config-wizard out, remove CS/ES only, change highlighted role
XInclude into current installing
XInclude into new ES installing
Update dependencies
Added:
trunk/refman-5.0/windows-config-wizard.xml
Modified:
trunk/refman-5.0/Makefile
trunk/refman-5.0/installing-es.xml
trunk/refman-5.0/installing.xml
Modified: trunk/refman-5.0/Makefile
===================================================================
--- trunk/refman-5.0/Makefile 2006-10-30 16:14:02 UTC (rev 3798)
+++ trunk/refman-5.0/Makefile 2006-10-30 16:34:12 UTC (rev 3799)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 6665 bytes
@@ -43,7 +43,7 @@
MANUAL_SRCS_EXTRA = versions.ent ../refman-common/fixedchars.ent ../refman-common/urls.ent ../refman-common/phrases.ent
-MANUAL_SRCS = $(MANUAL_SRCS_EXTRA) manual.xml ../refman-common/bug-reports.xml ../refman-common/cjk-faq.en.xml ../refman-common/credits.xml ../refman-common/environment-variables.xml ../refman-common/gpl-license.xml ../refman-common/information-sources.xml ../refman-common/manual-conventions.en.xml ../refman-common/maxdb.en.xml ../refman-common/mysql-floss-license-exception.xml ../refman-common/news-cluster.xml ../refman-common/news-connector-j.xml ../refman-common/news-connector-net.xml ../refman-common/news-myodbc.xml ../refman-common/regexp.xml ../refman-common/what-is-mysql-ab.en.xml ../refman-common/what-is.en.xml apis.xml charset.xml client-utility-programs.xml connector-j.xml connector-mxj.xml connector-net.xml connector-odbc.xml connector-php.xml connectors.xml copyright.xml data-types.xml database-administration.xml dba-optvars-table.xml errmsgs-client.xml errmsgs-server.xml error-handling.xml extending-mysql.xml functions.xml images/blackhole-1.png images/cluster-!
components-1.png images/cluster-upgrade-downgrade-table.png images/cmxj-overview.png images/cnet-win-install-step1.png images/cnet-win-install-step2.png images/cnet-win-install-step3.png images/cnet-win-install-step4.png images/cnet-win-install-step6.png images/multi-comp-1.png images/myaccess-odbc.png images/myaccess.png images/myarchitecture.png images/myflowchart.png images/myodbc-excel-step1.png images/myodbc-excel-step2.png images/myodbc-excel-step3.png images/myodbc-excel-step4.png images/myodbc-excel-step5.png images/myodbc-macosx-install-step1.png images/myodbc-macosx-install-step2.png images/myodbc-macosx-install-step3.png images/myodbc-macosx-install-step4.png images/myodbc-macosx-install-step5.png images/myodbc-macosx-install-step6.png images/myodbc-macosx-odbcadmin-adddsn.png images/myodbc-macosx-odbcadmin-main.png images/myodbc-macosx-odbcadmin-sampledsn.png images/myodbc-macosx-odbcadmin-tracing.png images/myodbc-win-install-step1.png images/myodbc-win-install!
-step2.png images/myodbc-win-install-step3.png images/myodbc-w!
in-insta
ll-step4.png images/myodbc-win-odbcadmin-adddsn.png images/myodbc-win-odbcadmin-advanced.png images/myodbc-win-odbcadmin-driverselect.png images/myodbc-win-odbcadmin-main.png images/myodbc-win-odbcadmin-options.png images/myodbc-win-odbcadmin-sampledsn.png images/myodbc-win-tracing.png images/ndb-size-pl-1.png images/replicas-groups-1-1.png images/replicas-groups-1-2.png information-schema.xml installing.xml introduction.xml language-structure.xml legalnotice.en.xml limits.xml mysql-cluster.xml news-5.0.xml news.xml optimization.xml porting.xml precision-math.xml preface.xml problems.xml releasenotes-cs-5.0.xml releasenotes-cs.xml releasenotes-es-5.0.xml releasenotes-es.xml replication.xml reserved-new-5.0.xml reservedwords.xml restrictions.xml se-archive.xml se-bdb.xml se-blackhole.xml se-csv.xml se-example.xml se-federated.xml se-innodb.xml se-memory.xml se-merge.xml se-myisam.xml spatial-extensions.xml sql-syntax.xml storage-engines.xml stored-procedures.xml triggers.xml !
tutorial.xml using-mysql-programs.xml views.xml
+MANUAL_SRCS = $(MANUAL_SRCS_EXTRA) manual.xml ../refman-common/bug-reports.xml ../refman-common/cjk-faq.en.xml ../refman-common/credits.xml ../refman-common/environment-variables.xml ../refman-common/gpl-license.xml ../refman-common/information-sources.xml ../refman-common/manual-conventions.en.xml ../refman-common/maxdb.en.xml ../refman-common/mysql-floss-license-exception.xml ../refman-common/news-cluster.xml ../refman-common/news-connector-j.xml ../refman-common/news-connector-net.xml ../refman-common/news-myodbc.xml ../refman-common/regexp.xml ../refman-common/what-is-mysql-ab.en.xml ../refman-common/what-is.en.xml apis.xml charset.xml client-utility-programs.xml connector-j.xml connector-mxj.xml connector-net.xml connector-odbc.xml connector-php.xml connectors.xml copyright.xml data-types.xml database-administration.xml dba-optvars-table.xml errmsgs-client.xml errmsgs-server.xml error-handling.xml extending-mysql.xml functions.xml images/blackhole-1.png images/cluster-!
components-1.png images/cluster-upgrade-downgrade-table.png images/cmxj-overview.png images/cnet-win-install-step1.png images/cnet-win-install-step2.png images/cnet-win-install-step3.png images/cnet-win-install-step4.png images/cnet-win-install-step6.png images/multi-comp-1.png images/myaccess-odbc.png images/myaccess.png images/myarchitecture.png images/myflowchart.png images/myodbc-excel-step1.png images/myodbc-excel-step2.png images/myodbc-excel-step3.png images/myodbc-excel-step4.png images/myodbc-excel-step5.png images/myodbc-macosx-install-step1.png images/myodbc-macosx-install-step2.png images/myodbc-macosx-install-step3.png images/myodbc-macosx-install-step4.png images/myodbc-macosx-install-step5.png images/myodbc-macosx-install-step6.png images/myodbc-macosx-odbcadmin-adddsn.png images/myodbc-macosx-odbcadmin-main.png images/myodbc-macosx-odbcadmin-sampledsn.png images/myodbc-macosx-odbcadmin-tracing.png images/myodbc-win-install-step1.png images/myodbc-win-install!
-step2.png images/myodbc-win-install-step3.png images/myodbc-w!
in-insta
ll-step4.png images/myodbc-win-odbcadmin-adddsn.png images/myodbc-win-odbcadmin-advanced.png images/myodbc-win-odbcadmin-driverselect.png images/myodbc-win-odbcadmin-main.png images/myodbc-win-odbcadmin-options.png images/myodbc-win-odbcadmin-sampledsn.png images/myodbc-win-tracing.png images/ndb-size-pl-1.png images/replicas-groups-1-1.png images/replicas-groups-1-2.png information-schema.xml installing.xml introduction.xml language-structure.xml legalnotice.en.xml limits.xml mysql-cluster.xml news-5.0.xml news.xml optimization.xml porting.xml precision-math.xml preface.xml problems.xml releasenotes-cs-5.0.xml releasenotes-cs.xml releasenotes-es-5.0.xml releasenotes-es.xml replication.xml reserved-new-5.0.xml reservedwords.xml restrictions.xml se-archive.xml se-bdb.xml se-blackhole.xml se-csv.xml se-example.xml se-federated.xml se-innodb.xml se-memory.xml se-merge.xml se-myisam.xml spatial-extensions.xml sql-syntax.xml storage-engines.xml stored-procedures.xml triggers.xml !
tutorial.xml using-mysql-programs.xml views.xml windows-config-wizard.xml
manual-prepped.xml: $(MANUAL_SRCS) $(IDMAP_OBJS)
manual-manprepped.xml: $(MANUAL_SRCS) $(IDMAP_OBJS)
Modified: trunk/refman-5.0/installing-es.xml
===================================================================
--- trunk/refman-5.0/installing-es.xml 2006-10-30 16:14:02 UTC (rev 3798)
+++ trunk/refman-5.0/installing-es.xml 2006-10-30 16:34:12 UTC (rev 3799)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 7; 898 bytes
@@ -451,16 +451,20 @@
Post-install procedures
-
+ After installation....
+
+
+ MySQL Server Configuration Wizard
+
-
- MySQL Server Configuration Wizard
-
-
-
+
MySQL Network Monitoring and Advisor Service Installer
-
+
+
+
+
+
Modified: trunk/refman-5.0/installing.xml
===================================================================
--- trunk/refman-5.0/installing.xml 2006-10-30 16:14:02 UTC (rev 3798)
+++ trunk/refman-5.0/installing.xml 2006-10-30 16:34:12 UTC (rev 3799)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 675; 26121 bytes
@@ -3333,681 +3333,8 @@
-
-
- Using the Configuration Wizard
- &cs-only;
-
-
- Introduction to the Configuration Wizard
- &cs-only;
-
-
- The MySQL Configuration Wizard helps automate the process of
- configuring your server under Windows. The MySQL Configuration
- Wizard creates a custom my.ini file by
- asking you a series of questions and then applying your
- responses to a template to generate a
- my.ini file that is tuned to your
- installation.
-
-
-
- The MySQL Configuration Wizard is included with the MySQL
- ¤t-series; server, and is currently available for
- Windows users only.
-
-
-
- The MySQL Configuration Wizard is to a large extent the result
- of feedback that MySQL AB has received from many users over a
- period of several years. However, if you find that it lacks
- some feature important to you, please report it in our bugs
- database using the instructions given in
- .
-
-
-
- END INTRODUCTION
-
-
-
-
-
-
- Starting the MySQL Configuration Wizard
- &cs-only;
-
- The MySQL Configuration Wizard is typically launched from the
- MySQL Installation Wizard, as the MySQL Installation Wizard
- exits. You can also launch the MySQL Configuration Wizard by
- clicking the MySQL Server Instance Config
- Wizard entry in the
- MySQL section of the Windows
- Start menu.
-
-
-
- Alternatively, you can navigate to the
- bin directory of your MySQL installation
- and launch the MySQLInstanceConfig.exe
- file directly.
-
-
-
- END STARTING
-
-
-
-
-
-
- Choosing a Maintenance Option
- &cs-only;
-
- If the MySQL Configuration Wizard detects an existing
- my.ini file, you have the option of
- either reconfiguring your existing server, or removing the
- server instance by deleting the my.ini
- file and stopping and removing the MySQL service.
-
-
-
- To reconfigure an existing server, choose the
- Re-configure Instance option and
- click the Next button. Your existing
- my.ini file is renamed to
- mytimestamp.ini.bak,
- where timestamp is the date and
- time at which the existing my.ini file
- was created. To remove the existing server instance, choose
- the Remove Instance option and
- click the Next button.
-
-
-
- If you choose the Remove Instance
- option, you advance to a confirmation window. Click the
- Execute button. The MySQL Configuration
- Wizard stops and removes the MySQL service, and then deletes
- the my.ini file. The server installation
- and its data folder are not removed.
-
-
-
- If you choose the Re-configure
- Instance option, you advance to the
- Configuration Type dialog where you can
- choose the type of installation that you wish to configure.
-
-
-
- END MAINTENANCE
-
-
-
-
-
-
- Choosing a Configuration Type
- &cs-only;
-
- When you start the MySQL Configuration Wizard for a new MySQL
- installation, or choose the Re-configure
- Instance option for an existing installation,
- you advance to the Configuration Type
- dialog.
-
-
-
- There are two configuration types available:
- Detailed Configuration and
- Standard Configuration. The
- Standard Configuration option is
- intended for new users who want to get started with MySQL
- quickly without having to make many decisions about server
- configuration. The Detailed
- Configuration option is intended for advanced
- users who want more fine-grained control over server
- configuration.
-
-
-
- If you are new to MySQL and need a server configured as a
- single-user developer machine, the Standard
- Configuration should suit your needs. Choosing
- the Standard Configuration option
- causes the MySQL Configuration Wizard to set all configuration
- options automatically with the exception of
- Service Options and
- Security Options.
-
-
-
- The Standard Configuration sets
- options that may be incompatible with systems where there are
- existing MySQL installations. If you have an existing MySQL
- installation on your system in addition to the installation
- you wish to configure, the Detailed
- Configuration option is recommended.
-
-
-
- To complete the Standard
- Configuration, please refer to the sections on
- Service Options and
- Security Options in
- , and
- , respectively.
-
-
-
- END STANDARD CONFIGURATION
-
-
-
- END CHOOSING TYPE
-
-
-
-
-
-
- The Server Type Dialog
- &cs-only;
-
- There are three different server types available to choose
- from. The server type that you choose affects the decisions
- that the MySQL Configuration Wizard makes with regard to
- memory, disk, and processor usage.
-
-
-
-
-
-
- Developer Machine: Choose this
- option for a typical desktop workstation where MySQL is
- intended only for personal use. It is assumed that many
- other desktop applications are running. The MySQL server
- is configured to use minimal system resources.
-
-
-
-
-
- Server Machine: Choose this
- option for a server machine where the MySQL server is
- running alongside other server applications such as FTP,
- email, and Web servers. The MySQL server is configured to
- use a moderate portion of the system resources.
-
-
-
-
-
- Dedicated MySQL Server Machine:
- Choose this option for a server machine that is intended
- to run only the MySQL server. It is assumed that no other
- applications are running. The MySQL server is configured
- to use all available system resources.
-
-
-
-
-
-
- END SERVER TYPE
-
-
-
-
-
-
- The Database Usage Dialog
- &cs-only;
-
- The Database Usage dialog allows you to
- indicate the storage engines that you expect to use when
- creating MySQL tables. The option you choose determines
- whether the InnoDB storage engine is
- available and what percentage of the server resources are
- available to InnoDB.
-
-
-
-
-
-
- Multifunctional Database: This
- option enables both the InnoDB and
- MyISAM storage engines and divides
- resources evenly between the two. This option is
- recommended for users who use both storage engines on a
- regular basis.
-
-
-
-
-
- Transactional Database Only:
- This option enables both the InnoDB and
- MyISAM storage engines, but dedicates
- most server resources to the InnoDB
- storage engine. This option is recommended for users who
- use InnoDB almost exclusively and make
- only minimal use of MyISAM.
-
-
-
-
-
- Non-Transactional Database
- Only: This option disables the
- InnoDB storage engine completely and
- dedicates all server resources to the
- MyISAM storage engine. This option is
- recommended for users who do not use
- InnoDB.
-
-
-
-
-
-
- END DATABASE USAGE
-
-
-
-
-
-
- The InnoDB Tablespace Dialog
- &cs-only;
-
- Some users may want to locate the InnoDB
- tablespace files in a different location than the MySQL server
- data directory. Placing the tablespace files in a separate
- location can be desirable if your system has a higher capacity
- or higher performance storage device available, such as a RAID
- storage system.
-
-
-
- To change the default location for the
- InnoDB tablespace files, choose a new drive
- from the drop-down list of drive letters and choose a new path
- from the drop-down list of paths. To create a custom path,
- click the ... button.
-
-
-
- If you are modifying the configuration of an existing server,
- you must click the Modify button before
- you change the path. In this situation you must move the
- existing tablespace files to the new location manually before
- starting the server.
-
-
-
- END TABLESPACE DIALOG
-
-
-
-
-
-
- The Concurrent Connections Dialog
- &cs-only;
-
- To prevent 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. The Concurrent
- Connections dialog allows you to choose the expected
- usage of your server, and sets the limit for concurrent
- connections accordingly. It is also possible to set the
- concurrent connection limit manually.
-
-
-
-
-
-
- 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.
-
-
-
-
-
- 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.
-
-
-
-
-
- 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.
-
-
-
-
-
-
- END CONCURRENT CONNECTIONS
-
-
-
-
-
-
- The Networking and Strict Mode Options Dialog
- &cs-only;
-
- Use the Networking Options dialog to enable
- or disable TCP/IP networking and to configure the port number
- that is used to connect to the MySQL server.
-
-
-
- TCP/IP networking is enabled by default. To disable TCP/IP
- networking, uncheck the box next to the Enable
- TCP/IP Networking option.
-
-
-
- Port 3306 is used by default. To change the port used to
- access MySQL, choose a new port number from the drop-down box
- or type a new port number directly into the drop-down box. If
- the port number you choose is in use, you are prompted to
- confirm your choice of port number.
-
-
-
- Set the Server SQL Mode to either enable or
- disable strict mode. Enabling strict mode (default) makes
- MySQL behave more like other database management systems.
- If you run applications that rely on MySQL's old
- forgiving behavior, make sure to either adapt
- those applications or to disable strict mode. For
- more information about strict mode, see
- .
-
-
-
- END NETWORKING AND STRICT MODE OPTIONS
-
-
-
-
-
-
- The Character Set Dialog
- &cs-only;
-
- The MySQL server supports multiple character sets and it is
- possible to set a default server character set that is applied
- to all tables, columns, and databases unless overridden. Use
- the Character Set dialog to change the
- default character set of the MySQL server.
-
-
-
-
-
-
- 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.
-
-
-
-
-
- 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.
-
-
-
-
-
- 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.
-
-
-
-
-
-
- END CHARACTER SET
-
-
-
-
-
-
- The Service Options Dialog
- &cs-only;
-
- On Windows NT-based platforms, the MySQL server can be
- installed as a Windows service. When installed this way, the
- MySQL server can be started automatically during system
- startup, and even restarted automatically by Windows in the
- event of a service failure.
-
-
-
- The MySQL Configuration Wizard installs the MySQL server as a
- service by default, using the service name
- MySQL. If you do not wish to install the
- service, uncheck the box next to the Install As
- Windows Service option. You can change the
- service name by picking a new service name from the drop-down
- box provided or by entering a new service name into the
- drop-down box.
-
-
-
- To install the MySQL server as a service but not have it
- started automatically at startup, uncheck the box next to the
- Launch the MySQL Server
- Automatically option.
-
-
-
- END SERVICE OPTIONS
-
-
-
-
-
-
- The Security Options Dialog
- &cs-only;
-
- It is strongly recommended that you set a
- root password for your MySQL
- server, and the MySQL Configuration Wizard requires
- by default that you do so. If you do not wish to set a
- root password, uncheck the box next to the
- Modify Security Settings option.
-
-
-
- To set the root password, enter the desired
- password into both the New root
- password and Confirm
- boxes. If you are reconfiguring an existing server, you need
- to enter the existing root password into
- the Current root password box.
-
-
-
- To prevent root logins from across the
- network, check the box next to the Root may only
- connect from localhost option. This increases
- the security of your root account.
-
-
-
- To create an anonymous user account, check the box next to the
- Create An Anonymous Account option.
- Creating an anonymous account can decrease server security and
- cause login and permission difficulties. For this reason, it
- is not recommended.
-
-
-
- END SECURITY OPTIONS
-
-
-
-
-
-
- The Confirmation Dialog
- &cs-only;
-
- The final dialog in the MySQL Configuration Wizard is the
- Confirmation Dialog. To start the
- configuration process, click the
- Execute button. To return to a previous
- dialog, click the Back button. To exit
- the MySQL Configuration Wizard without configuring the server,
- click the Cancel button.
-
-
-
- After you click the Execute button, the
- MySQL Configuration Wizard performs a series of tasks and
- displays the progress onscreen as the tasks are performed.
-
-
-
- The MySQL Configuration Wizard first determines configuration
- file options based on your choices using a template prepared
- by MySQL AB developers and engineers. This template is named
- my-template.ini and is located in your
- server installation directory.
-
-
-
- The MySQL Configuration Wizard then writes these options to a
- my.ini file. The final location of the
- my.ini file is displayed next to the
- Write configuration file task.
-
-
-
- If you chose to create a service for the MySQL server, the
- MySQL Configuration Wizard creates and starts the service. If
- you are reconfiguring an existing service, the MySQL
- Configuration Wizard restarts the service to apply your
- configuration changes.
-
-
-
- If you chose to set a root password, the
- MySQL Configuration Wizard connects to the server, sets your
- new root password and applies any other
- security settings you may have selected.
-
-
-
- After the MySQL Configuration Wizard has completed its tasks,
- it displays a summary. Click the Finish
- button to exit the MySQL Configuration Wizard.
-
-
-
- END CONFIRMATION DIALOG
-
-
-
-
-
-
- The Location of the my.ini File
- &cs-only;
-
- The MySQL Configuration Wizard places the
- my.ini file in the installation directory
- for the MySQL server. This helps associate configuration files
- with particular server instances.
-
-
-
- To ensure that the MySQL server knows where to look for the
- my.ini file, an argument similar to this
- is passed to the MySQL server as part of the service
- installation:
-
-
-
---defaults-file="C:\Program Files\MySQL\MySQL Server ¤t-series;\my.ini"
-
-
-
- Here, C:\Program Files\MySQL\MySQL Server
- ¤t-series; is replaced with the
- installation path to the MySQL Server. The
- option instructs the MySQL
- server to read the specified file for configuration options
- when it starts.
-
-
-
- END INI FILE LOCTAION
-
-
-
-
-
-
- Editing the my.ini File
- &cs-only;
-
- To modify the my.ini file, open it with a
- text editor and make any necessary changes. You can also
- modify the server configuration with the
- MySQL
- Administrator utility.
-
-
-
- MySQL clients and utilities such as the
- mysql and mysqldump
- command-line clients are not able to locate the
- my.ini file located in the server
- installation directory. To configure the client and utility
- applications, create a new my.ini file in
- the C:\WINDOWS or
- C:\WINNT directory (whichever is
- applicable to your Windows version).
-
-
-
-
-
-
+
+
Installing MySQL from a Noinstall Zip Archive
Added: trunk/refman-5.0/windows-config-wizard.xml
===================================================================
--- trunk/refman-5.0/windows-config-wizard.xml (rev 0)
+++ trunk/refman-5.0/windows-config-wizard.xml 2006-10-30 16:34:12 UTC (rev 3799)
Changed blocks: 1, Lines Added: 689, Lines Deleted: 0; 26316 bytes
@@ -0,0 +1,689 @@
+
+
+ %fixedchars.entities;
+
+ %urls.entities;
+
+ %phrases.entities;
+
+ %versions.entities;
+]>
+
+
+ Using the Configuration Wizard
+
+
+
+ Introduction to the Configuration Wizard
+
+
+
+ The MySQL Configuration Wizard helps automate the process of
+ configuring your server under Windows. The MySQL Configuration
+ Wizard creates a custom my.ini file by
+ asking you a series of questions and then applying your
+ responses to a template to generate a
+ my.ini file that is tuned to your
+ installation.
+
+
+
+ The MySQL Configuration Wizard is included with the MySQL
+ ¤t-series; server, and is currently available for
+ Windows users only.
+
+
+
+ The MySQL Configuration Wizard is to a large extent the result
+ of feedback that MySQL AB has received from many users over a
+ period of several years. However, if you find that it lacks
+ some feature important to you, please report it in our bugs
+ database using the instructions given in
+ .
+
+
+
+ END INTRODUCTION
+
+
+
+
+
+
+ Starting the MySQL Configuration Wizard
+
+
+ The MySQL Configuration Wizard is typically launched from the
+ MySQL Installation Wizard, as the MySQL Installation Wizard
+ exits. You can also launch the MySQL Configuration Wizard by
+ clicking the MySQL Server Instance Config
+ Wizard entry in the
+ MySQL section of the Windows
+ Start menu.
+
+
+
+ Alternatively, you can navigate to the
+ bin directory of your MySQL installation
+ and launch the MySQLInstanceConfig.exe
+ file directly.
+
+
+
+ END STARTING
+
+
+
+
+
+
+ Choosing a Maintenance Option
+
+
+ If the MySQL Configuration Wizard detects an existing
+ my.ini file, you have the option of
+ either reconfiguring your existing server, or removing the
+ server instance by deleting the my.ini
+ file and stopping and removing the MySQL service.
+
+
+
+ To reconfigure an existing server, choose the
+ Re-configure Instance option and
+ click the Next button. Your existing
+ my.ini file is renamed to
+ mytimestamp.ini.bak,
+ where timestamp is the date and
+ time at which the existing my.ini file
+ was created. To remove the existing server instance, choose
+ the Remove Instance option and
+ click the Next button.
+
+
+
+ If you choose the Remove Instance
+ option, you advance to a confirmation window. Click the
+ Execute button. The MySQL Configuration
+ Wizard stops and removes the MySQL service, and then deletes
+ the my.ini file. The server installation
+ and its data folder are not removed.
+
+
+
+ If you choose the Re-configure
+ Instance option, you advance to the
+ Configuration Type dialog where you can
+ choose the type of installation that you wish to configure.
+
+
+
+ END MAINTENANCE
+
+
+
+
+
+
+ Choosing a Configuration Type
+
+
+ When you start the MySQL Configuration Wizard for a new MySQL
+ installation, or choose the Re-configure
+ Instance option for an existing installation,
+ you advance to the Configuration Type
+ dialog.
+
+
+
+ There are two configuration types available:
+ Detailed Configuration and
+ Standard Configuration. The
+ Standard Configuration option is
+ intended for new users who want to get started with MySQL
+ quickly without having to make many decisions about server
+ configuration. The Detailed
+ Configuration option is intended for advanced
+ users who want more fine-grained control over server
+ configuration.
+
+
+
+ If you are new to MySQL and need a server configured as a
+ single-user developer machine, the Standard
+ Configuration should suit your needs. Choosing
+ the Standard Configuration option
+ causes the MySQL Configuration Wizard to set all configuration
+ options automatically with the exception of
+ Service Options and
+ Security Options.
+
+
+
+ The Standard Configuration sets
+ options that may be incompatible with systems where there are
+ existing MySQL installations. If you have an existing MySQL
+ installation on your system in addition to the installation
+ you wish to configure, the Detailed
+ Configuration option is recommended.
+
+
+
+ To complete the Standard
+ Configuration, please refer to the sections on
+ Service Options and
+ Security Options in
+ , and
+ , respectively.
+
+
+
+ END STANDARD CONFIGURATION
+
+
+
+ END CHOOSING TYPE
+
+
+
+
+
+
+ The Server Type Dialog
+
+
+ There are three different server types available to choose
+ from. The server type that you choose affects the decisions
+ that the MySQL Configuration Wizard makes with regard to
+ memory, disk, and processor usage.
+
+
+
+
+
+
+ Developer Machine: Choose this
+ option for a typical desktop workstation where MySQL is
+ intended only for personal use. It is assumed that many
+ other desktop applications are running. The MySQL server
+ is configured to use minimal system resources.
+
+
+
+
+
+ Server Machine: Choose this
+ option for a server machine where the MySQL server is
+ running alongside other server applications such as FTP,
+ email, and Web servers. The MySQL server is configured to
+ use a moderate portion of the system resources.
+
+
+
+
+
+ Dedicated MySQL Server Machine:
+ Choose this option for a server machine that is intended
+ to run only the MySQL server. It is assumed that no other
+ applications are running. The MySQL server is configured
+ to use all available system resources.
+
+
+
+
+
+
+ END SERVER TYPE
+
+
+
+
+
+
+ The Database Usage Dialog
+
+
+ The Database Usage dialog allows you to
+ indicate the storage engines that you expect to use when
+ creating MySQL tables. The option you choose determines
+ whether the InnoDB storage engine is
+ available and what percentage of the server resources are
+ available to InnoDB.
+
+
+
+
+
+
+ Multifunctional Database: This
+ option enables both the InnoDB and
+ MyISAM storage engines and divides
+ resources evenly between the two. This option is
+ recommended for users who use both storage engines on a
+ regular basis.
+
+
+
+
+
+ Transactional Database Only:
+ This option enables both the InnoDB and
+ MyISAM storage engines, but dedicates
+ most server resources to the InnoDB
+ storage engine. This option is recommended for users who
+ use InnoDB almost exclusively and make
+ only minimal use of MyISAM.
+
+
+
+
+
+ Non-Transactional Database
+ Only: This option disables the
+ InnoDB storage engine completely and
+ dedicates all server resources to the
+ MyISAM storage engine. This option is
+ recommended for users who do not use
+ InnoDB.
+
+
+
+
+
+
+ END DATABASE USAGE
+
+
+
+
+
+
+ The InnoDB Tablespace Dialog
+
+
+ Some users may want to locate the InnoDB
+ tablespace files in a different location than the MySQL server
+ data directory. Placing the tablespace files in a separate
+ location can be desirable if your system has a higher capacity
+ or higher performance storage device available, such as a RAID
+ storage system.
+
+
+
+ To change the default location for the
+ InnoDB tablespace files, choose a new drive
+ from the drop-down list of drive letters and choose a new path
+ from the drop-down list of paths. To create a custom path,
+ click the ... button.
+
+
+
+ If you are modifying the configuration of an existing server,
+ you must click the Modify button before
+ you change the path. In this situation you must move the
+ existing tablespace files to the new location manually before
+ starting the server.
+
+
+
+ END TABLESPACE DIALOG
+
+
+
+
+
+
+ The Concurrent Connections Dialog
+
+
+ To prevent 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. The Concurrent
+ Connections dialog allows you to choose the expected
+ usage of your server, and sets the limit for concurrent
+ connections accordingly. It is also possible to set the
+ concurrent connection limit manually.
+
+
+
+
+
+
+ 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.
+
+
+
+
+
+ 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.
+
+
+
+
+
+ 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.
+
+
+
+
+
+
+ END CONCURRENT CONNECTIONS
+
+
+
+
+
+
+ The Networking and Strict Mode Options Dialog
+
+
+ Use the Networking Options dialog to enable
+ or disable TCP/IP networking and to configure the port number
+ that is used to connect to the MySQL server.
+
+
+
+ TCP/IP networking is enabled by default. To disable TCP/IP
+ networking, uncheck the box next to the Enable
+ TCP/IP Networking option.
+
+
+
+ Port 3306 is used by default. To change the port used to
+ access MySQL, choose a new port number from the drop-down box
+ or type a new port number directly into the drop-down box. If
+ the port number you choose is in use, you are prompted to
+ confirm your choice of port number.
+
+
+
+ Set the Server SQL Mode to either enable or
+ disable strict mode. Enabling strict mode (default) makes
+ MySQL behave more like other database management systems.
+ If you run applications that rely on MySQL's old
+ forgiving behavior, make sure to either adapt
+ those applications or to disable strict mode. For
+ more information about strict mode, see
+ .
+
+
+
+ END NETWORKING AND STRICT MODE OPTIONS
+
+
+
+
+
+
+ The Character Set Dialog
+
+
+ The MySQL server supports multiple character sets and it is
+ possible to set a default server character set that is applied
+ to all tables, columns, and databases unless overridden. Use
+ the Character Set dialog to change the
+ default character set of the MySQL server.
+
+
+
+
+
+
+ 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.
+
+
+
+
+
+ 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.
+
+
+
+
+
+ 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.
+
+
+
+
+
+
+ END CHARACTER SET
+
+
+
+
+
+
+ The Service Options Dialog
+
+
+ On Windows NT-based platforms, the MySQL server can be
+ installed as a Windows service. When installed this way, the
+ MySQL server can be started automatically during system
+ startup, and even restarted automatically by Windows in the
+ event of a service failure.
+
+
+
+ The MySQL Configuration Wizard installs the MySQL server as a
+ service by default, using the service name
+ MySQL. If you do not wish to install the
+ service, uncheck the box next to the Install As
+ Windows Service option. You can change the
+ service name by picking a new service name from the drop-down
+ box provided or by entering a new service name into the
+ drop-down box.
+
+
+
+ To install the MySQL server as a service but not have it
+ started automatically at startup, uncheck the box next to the
+ Launch the MySQL Server
+ Automatically option.
+
+
+
+ END SERVICE OPTIONS
+
+
+
+
+
+
+ The Security Options Dialog
+
+
+ It is strongly recommended that you set a
+ root password for your MySQL
+ server, and the MySQL Configuration Wizard requires
+ by default that you do so. If you do not wish to set a
+ root password, uncheck the box next to the
+ Modify Security Settings option.
+
+
+
+ To set the root password, enter the desired
+ password into both the New root
+ password and Confirm
+ boxes. If you are reconfiguring an existing server, you need
+ to enter the existing root password into
+ the Current root password box.
+
+
+
+ To prevent root logins from across the
+ network, check the box next to the Root may only
+ connect from localhost option. This increases
+ the security of your root account.
+
+
+
+ To create an anonymous user account, check the box next to the
+ Create An Anonymous Account option.
+ Creating an anonymous account can decrease server security and
+ cause login and permission difficulties. For this reason, it
+ is not recommended.
+
+
+
+ END SECURITY OPTIONS
+
+
+
+
+
+
+ The Confirmation Dialog
+
+
+ The final dialog in the MySQL Configuration Wizard is the
+ Confirmation Dialog. To start the
+ configuration process, click the
+ Execute button. To return to a previous
+ dialog, click the Back button. To exit
+ the MySQL Configuration Wizard without configuring the server,
+ click the Cancel button.
+
+
+
+ After you click the Execute button, the
+ MySQL Configuration Wizard performs a series of tasks and
+ displays the progress onscreen as the tasks are performed.
+
+
+
+ The MySQL Configuration Wizard first determines configuration
+ file options based on your choices using a template prepared
+ by MySQL AB developers and engineers. This template is named
+ my-template.ini and is located in your
+ server installation directory.
+
+
+
+ The MySQL Configuration Wizard then writes these options to a
+ my.ini file. The final location of the
+ my.ini file is displayed next to the
+ Write configuration file task.
+
+
+
+ If you chose to create a service for the MySQL server, the
+ MySQL Configuration Wizard creates and starts the service. If
+ you are reconfiguring an existing service, the MySQL
+ Configuration Wizard restarts the service to apply your
+ configuration changes.
+
+
+
+ If you chose to set a root password, the
+ MySQL Configuration Wizard connects to the server, sets your
+ new root password and applies any other
+ security settings you may have selected.
+
+
+
+ After the MySQL Configuration Wizard has completed its tasks,
+ it displays a summary. Click the Finish
+ button to exit the MySQL Configuration Wizard.
+
+
+
+ END CONFIRMATION DIALOG
+
+
+
+
+
+
+ The Location of the my.ini File
+
+
+ The MySQL Configuration Wizard places the
+ my.ini file in the installation directory
+ for the MySQL server. This helps associate configuration files
+ with particular server instances.
+
+
+
+ To ensure that the MySQL server knows where to look for the
+ my.ini file, an argument similar to this
+ is passed to the MySQL server as part of the service
+ installation:
+
+
+
+--defaults-file="C:\Program Files\MySQL\MySQL Server ¤t-series;\my.ini"
+
+
+
+ Here, C:\Program Files\MySQL\MySQL Server
+ ¤t-series; is replaced with the
+ installation path to the MySQL Server. The
+ option instructs the MySQL
+ server to read the specified file for configuration options
+ when it starts.
+
+
+
+ END INI FILE LOCTAION
+
+
+
+
+
+
+ Editing the my.ini File
+
+
+ To modify the my.ini file, open it with a
+ text editor and make any necessary changes. You can also
+ modify the server configuration with the
+ MySQL
+ Administrator utility.
+
+
+
+ MySQL clients and utilities such as the
+ mysql and mysqldump
+ command-line clients are not able to locate the
+ my.ini file located in the server
+ installation directory. To configure the client and utility
+ applications, create a new my.ini file in
+ the C:\WINDOWS or
+ C:\WINNT directory (whichever is
+ applicable to your Windows version).
+
+
+
+
+
+
+