MariaDB drivers and management tools compatible with Azure Database for MariaDB
Important
Azure Database for MariaDB is on the retirement path. We strongly recommend that you migrate to Azure Database for MySQL. For more information about migrating to Azure Database for MySQL, see What's happening to Azure Database for MariaDB?.
This article describes the drivers and management tools that are compatible with Azure Database for MariaDB.
MariaDB Drivers
Azure Database for MariaDB uses the community edition of MariaDB server. Therefore, it's compatible with a wide variety of programming languages and drivers. The MariaDB API and protocol are compatible with those used by MySQL. This means that connectors that work with MySQL should also work with MariaDB.
The goal is to support the three most recent versions MariaDB drivers, and efforts with authors from the open source community to constantly improve the functionality and usability of MariaDB drivers continue. A list of drivers that have been tested and found to be compatible with Azure Database for MariaDB 10.2 is provided in the following table:
| Driver | Links | Compatible Versions | Incompatible Versions | Notes |
|---|---|---|---|---|
| PHP | https://secure.php.net/downloads.php | 5.5, 5.6, 7.x | 5.3 | For PHP 7.0 connection with SSL MySQLi, add MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT in the connection string. mysqli_real_connect($conn, $host, $username, $password, $db_name, 3306, NULL, MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);PDO set: PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT option to false. |
| .NET | MySqlConnector on GitHub Installation package from NuGet |
0.27 and after | 0.26.5 and before | |
| MySQL Connector/NET | MySQL Connector/NET | 8.0, 7.0, 6.10 | An encoding bug may cause connections to fail on some non-UTF8 Windows systems. | |
| Node.js | MySQLjs on GitHub Installation package from NPM: Run npm install mysql from NPM |
2.15 | 2.14.1 and before | |
| Go | https://github.com/go-sql-driver/mysql/releases | 1.3, 1.4 | 1.2 and before | Use allowNativePasswords=true in the connection string for version 1.3. Version 1.4 contains a fix and allowNativePasswords=true is no longer required. |
| Python | https://pypi.python.org/pypi/mysql-connector-python | 1.2.3, 2.0, 2.1, 2.2 | 1.2.2 and before | |
| Java | https://downloads.mariadb.org/connector-java/ | 2.1, 2.0, 1.6 | 1.5.5 and before |
Management Tools
The compatibility advantage extends to database management tools as well. Your existing tools should continue to work with Azure Database for MariaDB, as long as the database manipulation operates within the confines of user permissions. Three common database management tools that have been tested and found to be compatible with Azure Database for MariaDB 10.2 are listed in the following table:
| Action | MySQL Workbench 6.x and up | Navicat 12 | PHPMyAdmin 4.x and up |
|---|---|---|---|
| Create, Update, Read, Write, Delete | X | X | X |
| SSL Connection | X | X | X |
| SQL Query Auto Completion | X | X | |
| Import and Export Data | X | X | X |
| Export to Multiple Formats | X | X | X |
| Back up and Restore | X | ||
| Display Server Parameters | X | X | X |
| Display Client Connections | X | X | X |