How to install MySQL client on Windows

MySQL is a widely used open-source relational database system known for its performance and scalability. While MySQL is frequently deployed on Linux systems, many users also need to install the MySQL client on Windows to manage remote databases. This client provides the essential command-line tools required for interacting with MySQL servers, making it a convenient solution for administrators and developers.

Installing the MySQL client on Windows allows users to execute SQL queries and manage databases without the need to install the entire MySQL server. This is particularly useful for those who only require the ability to connect to and manage remote databases. The installation process is straightforward, ensuring quick setup on Windows environments.

This guide outlines the steps to download, install, and configure the MySQL client on Windows. Whether you're looking to install the MySQL client for Windows for development, testing, or administration, these instructions will help you get started efficiently.

1. Go to the official MySQL download page.
2. Select MySQL Installer for Windows.
3. Download the installer file.
4. Run the installer.
5. Choose the “Custom” installation option.
6. In the list of components, select “MySQL Client”.
7. Proceed with the installation.
8. After installation, open the MySQL client from the Start Menu.
9. Connect to a remote MySQL server.

   $ mysql -h 192.168.1.15 -u db_admin -p 

   When prompted, enter the password associated with the specified username.

   Enter password: **********
   Welcome to the MySQL monitor. Commands end with ; or \g.
   Your MySQL connection id is 8
   Server version: 8.0.27 MySQL Community Server - GPL

10. After connecting, you can start executing SQL queries to manage the databases.