- 2.3 Installing MySQL on Windows
- 2.3.1 Choosing An Installation Package
- 2.3.2 Installing MySQL with the Automated Installer
- 2.3.3 Using the MySQL Installation Wizard
- 2.3.4 MySQL Server Instance Configuration Wizard
- 2.3.5 Installing MySQL from a Noinstall Zip Archive
- 2.3.6 Extracting the Install Archive
- 2.3.7 Creating an Option File
- 2.3.8 Selecting a MySQL Server Type
- 2.3.9 Starting the Server for the First Time
- 2.3.10 Starting MySQL from the Windows Command Line
- 2.3.11 Starting MySQL as a Windows Service
- 2.3.12 Testing The MySQL Installation
- 2.3.13 Troubleshooting a MySQL Installation Under Windows
- 2.3.14 Upgrading MySQL on Windows
- 2.3.15 MySQL on Windows Compared to MySQL on Unix
The following table shows the available servers for Windows in MySQL 5.1.20 and earlier.
| Binary | Description |
| mysqld-nt | Optimized binary with named-pipe support |
| mysqld | Optimized binary without named-pipe support |
| mysqld-debug | Like mysqld-nt, but compiled with full debugging and automatic memory allocation checking |
The following table shows the available servers for Windows in MySQL 5.1.21 and later.
| Binary | Description |
| mysqld | Optimized binary with named-pipe support |
| mysqld-debug | Like mysqld, but compiled with full debugging and automatic memory allocation checking |
All of the preceding binaries are optimized for modern Intel processors, but should work on any Intel i386-class or higher processor.
Each of the servers in a distribution support the same set of
storage engines. The SHOW ENGINES
statement displays which engines a given server supports.
All Windows MySQL 5.1 servers have support for symbolic linking of database directories.
MySQL supports TCP/IP on all Windows platforms. MySQL servers on Windows support named pipes as indicated in the following list. However, the default is to use TCP/IP regardless of platform. (Named pipes are slower than TCP/IP in many Windows configurations.)
Use of named pipes is subject to these conditions:
Named pipes are enabled only if you start the server with the
--enable-named-pipeoption. It is necessary to use this option explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used.For MySQL 5.1.20 and earlier, named-pipe connections are allowed only by the mysqld-nt and mysqld-debug servers. For MySQL 5.1.21 and later, the mysqld and mysqld-debug servers both contain support for named-pipe connections.
Note
Most of the examples in this manual use mysqld as the server name. If you choose to use a different server, such as mysqld-nt or mysqld-debug, make the appropriate substitutions in the commands that are shown in the examples.
User Comments
"Named pipes are slower than TCP/IP in many Windows configurations"? Which "configurations"? If connecting to a DB on localhost, it should be faster. Please clarify.
Add your own comment.