MySQL :: MySQL 8.0 Reference Manual :: 2.3 Installing MySQL on Microsoft Windows

2.3 Installing MySQL on Microsoft Windows

Important

MySQL 8.0 Server requires the Microsoft Visual C++
2019 Redistributable Package to run on Windows platforms. Users
should make sure the package has been installed on the system
before installing the server. The package is available at the
Microsoft
Download Center. Additionally, MySQL debug binaries
require Visual Studio 2019 to be installed.

MySQL is available for Microsoft Windows 64-bit operating systems
only. For supported Windows platform information, see
https://www.mysql.com/support/supportedplatforms/database.html.

There are different methods to install MySQL on Microsoft Windows.

MySQL Installer Method

The simplest and recommended method is to download MySQL Installer (for
Windows) and let it install and configure a specific version of
MySQL Server as follows:

1. Download MySQL Installer from https://dev.mysql.com/downloads/installer/
   and execute it.

   note

   Unlike the standard MySQL Installer, the smaller
   web - community version is bundle does not bundle any
   mysql application , but download only the mysql product you
   choose to install .

2. Determine the setup type to use for the initial installation of
   MySQL products. For example:

   • Developer Default: Provides a setup
     type that includes the selected version of MySQL Server and
     other MySQL tools related to MySQL development, such as
     MySQL Workbench.

   • Server Only: Provides a setup for the
     selected version of MySQL Server without other products.

   • Custom: Enables you to select any
     version of MySQL Server and other MySQL products.

3. Install the server instance (and products) and then begin the
   server configuration by following the onscreen instructions. For
   more information about each individual step, see
   Section 2.3.3.3.1, “MySQL Server Configuration with MySQL Installer”.

MySQL is now installed. If you configured MySQL as a service, then
Windows automatically starts the MySQL server every time you restart
the system. Also, this process installs the MySQL Installer application on the
local host, which you can use later to upgrade or reconfigure MySQL
server.

note

If you installed MySQL Workbench on your system, consider using it to
check your new MySQL server connection. By default, the program
automatically start after installing MySQL.

additional Installation Information

It is possible to run MySQL as a standard application or as a
Windows service. By using a service, you can monitor and control the
operation of the server through the standard Windows service
management tools. For more information, see
Section 2.3.4.8, “Starting MySQL as a Windows Service”.

To accommodate the restart statement ,
the MySQL server fork when run as a service or standalone , to
enable a monitor process to supervise the server process . In this
case , there are twomysqld processes. If
restart capability is not require ,
the server can be start with the
--no-monitor option. See
Section 15.7.8.8, “restart Statement”.

Generally, you should install MySQL on Windows using an account that
has administrator rights. Otherwise, you may encounter problems with
certain operations such as editing the PATH
environment variable or access theService Control
Manager. When installed, MySQL does not need to be
executed using a user with Administrator privileges.

For a list of limitations on the use of MySQL on the Windows
platform, see Section 2.3.7, “Windows Platform Restrictions”.

In addition to the MySQL Server package, you may need or want
additional components to use MySQL with your application or
development environment. These include, but are not limited to:

• To connect to the MySQL server using ODBC, you must have a
  Connector/ODBC driver. For more information, including
  installation and configuration instructions, see
  MySQL Connector/ODBC Developer Guide.

  note

  MySQL Installer installs and configures Connector/ODBC for you.

• To use MySQL server with .NET applications, you must have the
  Connector/NET driver. For more information, including installation and
  configuration instructions, see MySQL Connector/NET Developer Guide.

  note

  MySQL Installer installs and configures MySQL Connector/NET for you.

MySQL distributions for Windows can be downloaded from
https://dev.mysql.com/downloads/. See
Section 2.1.3, “How to Get MySQL”.

MySQL for Windows is available in several distribution formats,
detailed here. Generally speaking, you should use MySQL Installer. It contains
more features and MySQL products than the older MSI, is simpler to
use than the compressed file, and you need no additional tools to
get MySQL up and running. MySQL Installer automatically installs MySQL Server
and additional MySQL products, creates an options file, starts the
server, and enables you to create default user accounts. For more
information on choosing a package, see
Section 2.3.2, “Choosing an Installation Package”.

MySQL on Windows Considerations

• Large Table Support

  If you need tables with a size larger than 4GB, install MySQL on
  an NTFS or newer file system. Do not forget to use
  MAX_ROWS and
  AVG_ROW_LENGTH when you create tables. See
  Section 15.1.20, “CREATE TABLE Statement”.

• MySQL and Virus Checking
  Software

  virus – scan software is cause such as Norton / Symantec Anti – Virus is cause on
  directory contain mysql datum and temporary table can cause
  issue , both in term of the performance of mysql and the
  virus – scan software misidentify the content of the file
  as contain spam . This is is is due to the fingerprinting mechanism
  used by the virus – scan software , and the way in which mysql
  rapidly update different file , which may be identify as a
  potential security risk .

  After installing MySQL Server, it is recommended that you
  disable virus scanning on the main directory
  (datadir) used to store your
  mysql table datum . There is usually a system build into the
  virus – scan software to enable specific directory to be
  ignore .

  In addition, by default, MySQL creates temporary files in the
  standard Windows temporary directory. To prevent the temporary
  files also being scanned, configure a separate temporary
  directory for MySQL temporary files and add this directory to
  the virus scanning exclusion list. To do this, add a
  configuration option for the
  tmpdir parameter to your
  my.ini configuration file . For more
  information , see Section   2.3.4.2 , “ create an option file ” .