The classic MySQL client runs SQL statements from a Windows 11 terminal. Oracle's Windows ZIP package includes mysql.exe, so a workstation can have the MySQL client without configuring a local database server.

The Windows client is supplied as an x64 binary and needs Microsoft's Visual C++ runtime. The standard MySQL Community Server ZIP contains the client alongside server programs; extracting it does not create a database or start a Windows service.

A user Path entry lets new terminals find the extracted bin directory. The folder must stay in place, and an existing MySQL installation can affect which mysql command Windows finds.

Related: How to install MySQL server on Windows
Related: How to enable remote access to MySQL or MariaDB server

Steps to install MySQL client on Windows:

  1. Open the MySQL Community Server downloads page in a browser.
  2. Select the 9.7 LTS release from Select Version.

    The patch number may change; the downloaded release shown here is 9.7.4 LTS.

  3. Click Download beside the standard Windows (x86, 64-bit), ZIP Archive package.

    If another operating system is shown, choose Microsoft Windows under Select Operating System. The separate Debug Binaries & Test Suite archive is not needed.

  4. Click No thanks, just start my download.
  5. Download Microsoft's Visual C++ v14 Redistributable for x64.

    The x64 package matches the MySQL binary. Microsoft maintains the download links on its supported Visual C++ Redistributable page.

  6. Open VC_redist.x64.exe from the browser's Downloads panel.
  7. Select I agree to the license terms and conditions after reading the terms.

    The installer adds shared Microsoft runtime libraries to Windows and requires administrator approval.

  8. Click Install.

    If the runtime is already installed, the installer may offer Repair and Uninstall instead; no uninstall is needed for MySQL.

  9. Approve the User Account Control prompt for the installer from Microsoft Corporation.
  10. Click Close after Setup Successful appears.
  11. Open the downloaded MySQL ZIP from the browser's Downloads panel.
  12. Open the See more menu on File Explorer's toolbar.
  13. Select Extract all.
  14. Set the extraction destination to C:\Tools.

    The archive contains its own versioned folder, giving a location such as C:\Tools\mysql-9.7.4-winx64. A permanent folder avoids losing the client when Downloads is cleared.

  15. Click Extract.
  16. Open Edit environment variables for your account from Start.

    Replacing or deleting existing Path entries can stop other commands working. Adding a new entry preserves them; removing only that new entry reverses the PATH change.

  17. Select Path under User variables.
  18. Click Edit beneath the User variables list.
  19. Click New in Edit environment variable.
  20. Enter the extracted MySQL bin directory in the new entry. 
    C:\Tools\mysql-9.7.4-winx64\bin

    The folder name must match the downloaded version, and the path ends in \bin rather than \mysql.exe.

  21. Click OK in Edit environment variable.
  22. Click OK in Environment Variables to save the user Path.
  23. Open a new Command Prompt window from Start.

    A terminal that was already open can retain the old Path.

  24. Check that Windows finds the extracted MySQL client. 
    C:\>where.exe mysql
C:\Tools\mysql-9.7.4-winx64\bin\mysql.exe

    If no path is returned, a newly opened terminal and the exact extracted bin path are the first things to check. Multiple results indicate other installed copies; the first result takes precedence.

  25. Confirm that the MySQL client runs. 
    C:\>mysql --version
mysql  Ver 9.7.4 for Win64 on x86_64 (MySQL Community Server - GPL)

    The version reflects the downloaded release. A MySQL version line confirms that mysql.exe starts without a missing-runtime error; a database connection additionally requires a reachable server and a MySQL account.

Share this guide