- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 2.3.4 Using the Configuration Wizard
- 2.3.4.1 Introduction to the Configuration Wizard
- 2.3.4.2 Starting the MySQL Configuration Wizard
- 2.3.4.3 Choosing a Maintenance Option
- 2.3.4.4 Choosing a Configuration Type
- 2.3.4.5 The Server Type Dialog
- 2.3.4.6 The Database Usage Dialog
- 2.3.4.7 The InnoDB Tablespace Dialog
- 2.3.4.8 The Concurrent Connections Dialog
- 2.3.4.9 The Networking and Strict Mode Options Dialog
- 2.3.4.10 The Character Set Dialog
- 2.3.4.11 The Service Options Dialog
- 2.3.4.12 The Security Options Dialog
- 2.3.4.13 The Confirmation Dialog
- 2.3.4.14 The Location of the my.ini File
- 2.3.4.15 Editing the my.ini File
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 Section 5.1.7, “Server SQL Modes”.
User Comments
Add your own comment.