All pages
Powered by GitBook
1 of 4

Client Libraries

Explore server and client software for MariaDB. This section introduces various tools and applications for connecting to, managing, and interacting with your MariaDB Server instances effectively.

Connect and Query

Database connections are made using a connector (from an application) or a client (interactively or from scripts).

Clients and connectors listed here are supported under MariaDB Corporation Engineering Policies.

Clients and connectors listed here are compatible with:

  • MariaDB database products (including Enterprise Server and MaxScale)

  • MariaDB Community Server

MariaDB Connectors

MariaDB Connectors are available for many popular programming languages.

Programming Language / Interface
Connector

C

MariaDB Connector/C

C++

MariaDB Connector/C++

Java - JDBC

MariaDB Connector/J

Java - R2DBC

MariaDB Connector/R2DBC

JavaScript

MariaDB Connector/Node.js

ODBC

MariaDB Connector/ODBC

Python

MariaDB Connector/Python

MariaDB Client

MariaDB Client can be used interactively or within scripts.

MariaDB Client is included with distributions of MariaDB database products.

Compatible third-party clients exist but are not listed here.

Executable Filename
Purpose

mariadb, mysql

Connect from the command line

For additional information about MariaDB Client, see MariaDB Client.

Tools and Utilities

Tools and utilities listed here are included with distributions of MariaDB database products and make a client connection.

Command-Line Executable
Purpose

mariadb-admin, mysqladmin

Check configuration and current status

mariadb-backup, mariadb-backup

Create and restore physical backups (including Aria, InnoDB, MyISAM, MyRocks)

mariadb-binlog, mysqlbinlog

Read binary logs or relay logs

mariadb-check, mysqlcheck

Perform table maintenance operations

mariadb-dump, mysqldump

Create logical backups

mariadb-import, mysqlimport

Load table data from CSV, TSV, and other text file formats

mariadb-show, mysqlshow

Display databases, tables, table columns, indexes

mariadb-slap, mysqlslap

Generate client load for testing

Business Intelligence (BI)

MariaDB database products are accessible from business intelligence (BI) platforms, including:

BI Platform
Detail

Microsoft Power BI

MariaDB Direct Query Adapter for Microsoft Power BI enables Microsoft Power BI Desktop users to remotely connect to and query their MariaDB database, including on MariaDB SkySQL, without downloading the entire data set to their local machine.

This page is: Copyright © 2025 MariaDB. All rights reserved.

Proxy Protocol Support

The proxy protocol allows proxy programs to relay the IP of the clients to the server programs. It is important in case of MariaDB, since IP information is actually a part of user identity.

How Proxy Protocol Works

As per the proxy protocol specification, the connecting client can prefix its first packet with a proxy protocol header. The server will parse the header and assume the client's IP address is the one set in the proxy header.

For example, if a client sends the proxy header (V1, text) which is "PROXY TCP4 192.168.0.1 192.168.0.11 56324 443\r\n", the server, after parsing, assumes the client's IP is 192.168.0.1

MariaDB server understands both Version 1 (text) and Version 2 (binary) of the proxy header.

If the protocol specified by the version 1 header is "UNKNOWN", MariaDB server will treat the connection as if proxy protocol was disabled. This can be used when a valid proxy protocol header is needed but there is no client to proxy, for example when a proxy does a health check.

Enabling Proxy Protocol in MariaDB Server

To enable use of the proxy protocol, it is necessary to specify subnetworks that are allowed to send proxy headers, using the proxy-protocol-networks server variable.

proxy-protocol-networks is a either comma-separated list of (sub) networks or IP addresses. One also can use 'localhost' in this list, which means Unix domain socket/named pipe/shared memory connections are allowed as well. Or, proxy-protocol-networks can be set to *, meaning that proxy headers are allowed from any client.

Note that a client running on a host within an allowed proxy network or an IP address can itself pretend as being connected from any IP address whatsoever and thus can possibly impersonate other users. Generally, you should limit shell access to proxy hosts to a minimum. And remember, with proxy-protocol-networks=* every host is a proxy host.

Example in my.ini/my.cnf

proxy-protocol-networks=::1, 192.168.0.0/16, localhost

allows IPv6 connections from local machine ::1, from IP addresses starting with 192.168, and from connections made with Unix domain sockets or named pipes.

Client-Side Support for Proxy Protocol

Since the functionality is suited only to very specific proxy-like programs, most client APIs do not provide support for sending proxy headers. One exception is Connector/C version 3 or later. One can now use mysql_optionsv():

mysql_optionsv(mysql, MARIADB_OPT_PROXY_HEADER, header,  header_size)

prior to mysql_real_connect() or mysql_connect(), to send the header. In the call above _header_ is the proxy header with the type void *, and _header_size_ is its size in bytes (type is size_t).

Example

const char *hdr="PROXY TCP4 192.168.0.1 192.168.0.11 56324 443\r\n";
mysql_optionsv(mysql, MARIADB_OPT_PROXY_HEADER, hdr,  strlen(hdr));

Using Proxy Protocol with MariaDB MaxScale

If you want to use proxy protocol with MaxScale:

  • Add the IP address of the MaxScale server to proxy-protocol-networks

  • In maxscale.cnf, add the proxy_protocol parameter for all configured servers

Once configured, MaxScale will proxy the credentials from the client to the server.

See Also

  • Proxy Protocol

This page is licensed: CC BY-SA / Gnu FDL

Client/Server Protocol

Find detailed descriptions in the Reference section:

Client/Server Protocol