MariaDB ODBC Driver helps to connect databases from object-oriented and object-based programming languages. At Bobcares, with our Server Management Service, we can handle your MariaDB issues.

MariaDB ODBC Driver

MariaDB ODBC Driver is a database driver that uses the industry standard Open Database Connectivity (ODBC) API. The most recent Stable (GA) release of MariaDB Connector/ODBC is MariaDB Connector/ODBC 3.1.16. The key attributes of the driver include:

1. It can replace MySQL Connector/ODBC.
2. ODBC securely connects to contemporary cryptography technologies like SHA-256, TLS 1.2, and ECC.
3. It also provides support for both Unicode and ANSI modes.
4. It primarily employs the binary MariaDB/MySQL protocol.
5. ODBC supports 32-bit as well as 64-bit applications.
6. MariaDB Connector/ODBC is a cross-platform technology. So we can use it along Windows, Mac, or Linux systems.

Installing MariaDB Connector/ODBC

On Windows: The MSI packages install the driver on Windows. The installation of MSI is a fairly simple process. On Windows, MariaDB Connector/ODBC supports the built-in ODBC Driver Manager. So we don’t need to install any software additionally. MariaDB Connector/ODBC will even be registered with the ODBC Driver Manager as part of the MSI installation process, making it immediately usable.

On Linux: We require binary tarball packages in order to install MariaDB Connector/ODBC on Linux. Following are the installation instructions for a few popular Linux distributions.

1. Installation on RHEL/CentOS: On RHEL or CentOS, run the following commands in order to download and install MariaDB Connector/ODBC:

   mkdir odbc_package
   cd odbc_package
   wget https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.7/mariadb-connector-odbc-3.1.7-ga-rhel7-x86_64.tar.gz
   tar -xvzf mariadb-connector-odbc-3.1.7-ga-rhel7-x86_64.tar.gz
   sudo install lib64/libmaodbc.so /usr/lib64/
   sudo install -d /usr/lib64/mariadb/
   sudo install -d /usr/lib64/mariadb/plugin/
   sudo install lib64/mariadb/plugin/auth_gssapi_client.so /usr/lib64/mariadb/plugin/
   sudo install lib64/mariadb/plugin/caching_sha2_password.so /usr/lib64/mariadb/plugin/
   sudo install lib64/mariadb/plugin/client_ed25519.so /usr/lib64/mariadb/plugin/
   sudo install lib64/mariadb/plugin/dialog.so /usr/lib64/mariadb/plugin/
   sudo install lib64/mariadb/plugin/mysql_clear_password.so /usr/lib64/mariadb/plugin/
   sudo install lib64/mariadb/plugin/sha256_password.so /usr/lib64/mariadb/plugin/

    
2. Installation on Debian/Ubuntu: The following commands will download and install MariaDB Connector/ODBC on Debian or Ubuntu.

   mkdir odbc_package
   cd odbc_package
   wget https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.7/mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz
   tar -xvzf mariadb-connector-odbc-3.1.7-ga-debian-x86_64.tar.gz
   sudo install lib64/libmaodbc.so /usr/lib/
   sudo install -d /usr/lib/mariadb/
   sudo install -d /usr/lib/mariadb/plugin/
   sudo install lib/mariadb/plugin/auth_gssapi_client.so /usr/lib/mariadb/plugin/
   sudo install lib/mariadb/plugin/caching_sha2_password.so /usr/lib/mariadb/plugin/
   sudo install lib/mariadb/plugin/client_ed25519.so /usr/lib/mariadb/plugin/
   sudo install lib/mariadb/plugin/dialog.so /usr/lib/mariadb/plugin/
   sudo install lib/mariadb/plugin/mysql_clear_password.so /usr/lib/mariadb/plugin/
   sudo install lib/mariadb/plugin/sha256_password.so /usr/lib/mariadb/plugin/

    

On Mac OS: There are PKG packages for MariaDB Connector/ODBC releases beginning with MariaDB Connector/ODBC 3.1, which can be installed on Mac OS X. On Mac OS X, MariaDB Connector/ODBC supports the built-in iODBC Driver Manager, so there is no need for additional software.

How to make use of MariaDB ODBC Driver?

By using the standard command as shown below, we can connect a MariaDB database to an application.

MySQL

The default parameters taken from the configuration file are as follows after typing the aforementioned command:

Host is localhost

User is the login name of ODBC on the windows platform or login name of Unix.

Password is not passed as a parameter.

Although there is a connection between the client and the server, there is no link to any specific server-side database. If not using the default 3306 port address, then we can use -port = address of port number or -P port number to specify any other port to connect with.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To sum up, our Support team went over the MariaDB ODBC Driver details including its installation.