MariaDB is an open-source relational database system, forked from MySQL, and designed for compatibility and improved performance. While it is primarily used on Linux systems, the MariaDB client is available for Windows, providing the necessary tools to connect and manage remote MariaDB databases.
For users on Windows, the MariaDB client offers a way to interact with remote servers without installing the entire server locally. It allows administrators and developers to execute SQL queries and manage databases efficiently through a command-line interface.
This guide details the steps to install the MariaDB client on a Windows machine, focusing on setting up the necessary components for remote database management.
Steps to install MariaDB client on Windows:
- Go to the official MariaDB download page.
- Select the appropriate Windows version (32-bit or 64-bit).
- Download the MariaDB client installer.
- Run the downloaded installer.
- Follow the installation prompts.
- Select “Client utilities” during installation.
- Complete the installation.
- Open the MariaDB client from the Start Menu.
- Connect to a remote MariaDB server.
$ mysql -h 192.168.1.10 -u admin_user -p
When prompted, enter the password associated with the specified username.
Enter password: ********** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 10.5.9-MariaDB-1:10.5.9+maria~focal MariaDB Server
- After connecting, start executing SQL commands to manage the databases.
Mohd Shakir Zakaria is an experienced cloud architect with a strong development and open-source advocacy background. He boasts multiple certifications in AWS, Red Hat, VMware, ITIL, and Linux, underscoring his expertise in cloud architecture and system administration.
Comment anonymously. Login not required.