- 1 Installing MySQL on Windows
- 1.1 Choosing An Installation Package
- 1.2 Installing MySQL with the Automated Installer
- 1.3 Using the MySQL Installation Wizard
- 1.4 MySQL Server Instance Configuration Wizard
- 1.5 Installing MySQL from a Noinstall Zip Archive
- 1.6 Extracting the Install Archive
- 1.7 Creating an Option File
- 1.8 Selecting a MySQL Server Type
- 1.9 Starting the Server for the First Time
- 1.10 Starting MySQL from the Windows Command Line
- 1.11 Starting MySQL as a Windows Service
- 1.12 Testing The MySQL Installation
- 1.13 Troubleshooting a MySQL Installation Under Windows
- 1.14 Upgrading MySQL on Windows
- 1.15 MySQL on Windows Compared to MySQL on Unix
The following table shows the available servers for Windows in MySQL 5.4.
| 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.4 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.)
Named pipes are enabled only if you start the server with the
--enable-named-pipe option. 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.
