dbdeployer is a tool for installing multiple versions of MariaDB or MySQL in isolation from each other. It is primarily used for easily testing different server versions. It is written in Go, and is a replacement for MySQL Sandbox.

Visit www.dbdeployer.com for details on how to install and use it.

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

Syntax

Description

mariadb-setpermission is a Perl script that was originally written and contributed by Luuk de Boer. It requires the DBI and DBD::mysql Perl modules to be installed.mariadb-setpermission

mariadb-access is a tool for checking access privileges, developed by Yves Carlier.

It checks the access privileges for a host name, user name, and database combination.

Usage

If your MariaDB distribution is installed in some non-standard location, you must change the location where mariadb-access expects to find the mariadb client. Edit the mariadb-access script at approximately line 18. Search for a line that looks like this:

Change the path to reflect the location where the mariadb client tool is stored on your system. Otherwise, a Broken pipe error occurs when running mariadb-access.

Options

Note

At least the user (-u) and the database (-d) options must be given, even when using wildcards. If no host is provided, `localhost' is assumed. Wildcards (?, %, and _) are allowed for host, user, and database, but be sure to escape them from your shell.

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

Adminer is a database administration web interface. It is usable via a web browser. It is written in PHP and requires a web server.

Adminer mainly supports MySQL, but it also supports MariaDB and other database management systems. Adminer has a wide range of plugins, some of which have been developed by the community.

Adminer is distributed with a dual license: Apache License 2.0 and GPL 2. Adminer does not have a commercial edition, but it accepts donations.

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

dbForge Fusion is an add-in for Visual Studio. It provides automatic and simple MariaDB database development, and boosts data management capacity. With this tool integrated, it is easy to work with database development and administration tasks from Visual Studio.

DbSchema helps you design, document and manage databases. Design new tables, generate HTML5 documentation, explore and edit the database data, compare and synchronize the schema over multiple databases, edit and execute SQL, and generate random data.

DbSchema is compatible with all relational and some No-SQL databases. It works on all major operating systems, including Windows, Linux and macOS.

You can download and evaluate DbSchema 15 days for free.

DBSchema Webpage

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

DbVisualizer is a cross-platform database tool for developers, DBAs, analysts and SQL programmers. Both Free and paid Pro versions are available. Supported databases include MySQL, MariaDB, and PostgreSQL.

DbVisualizer has been carefully developed by a small and dedicated team. Development decisions are based on user feedback.

Example of features:

• Simple navigation of database objects and their properties.

• Visual rendering of primary/foreign keys.

• Table data editing in spreadsheet with Export and import database schema.

• Flexible user interface in light and dark themes.

• Query optimization with an explain plan feature.

• Visual query builder using drag and drop.

• Flexible SQL scripts execution with parameter support.

• SQL formatting and Command-line interface for headless execution.

• .

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

Sequel Pro is a fast, database management application for working with MySQL and MariaDB databases. It runs on macOS only.

Sequel Pro is open source, so it's easy to be involved and enhance it for MariaDB.

If you have any issues with Sequel Pro on MariaDB, please use the issue tracking for that!

See Also

• Sequal Pro home site

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

mycli is a command-line interface for MariaDB, MySQL, and Percona, with auto-completion and syntax highlighting. It is written in Python, and runs on Linux, Mac and Windows.

Read more at mycli.net.

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

phpMyAdmin is a web-based tool for administering MariaDB and MySQL.

It requires a web server, PHP, and a browser.

Read more at phpmyadmin.net.

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

Generate and populate databases with large volumes of realistic test data.

SB Data Generator is a simple and powerful GUI tool for creating large volumes of realistic test data to populate selected tables or entire databases. The tool reverses your database and displays tables and columns, so you can assign to them multiple data generator templates. It includes multiple built-in generators that allow populating MariaDB database tables with realistic data of various types.

Key Benefits:

• Understand your database structure by visualizing the ER Diagram (tables, columns, relationships, keys, sequences, indexes, and triggers).

• Ability to generate a large volume of realistic test data.

• Preview what data is generated before populating the database with test data.

• Multiple built-in generators available with the ability to create custom data generators.

• Generate test data for most popular DBMS including MariaDB and MySQL.

.

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

Toad Edge is a database management application that allows you to perform database administration tasks with ease.

Toad Edge allows you to:

• Connect to your MySQL database, view, explore and edit database structure, database objects and properties.

• Manage database objects, easily add, edit or drop objects in Object Explorer.

• Manage data stored in your database, add, edit or remove records.

• Write complex SQL code comfortably in Worksheet.

• Compare and synchronize databases using powerful Schema Compare.

• Obtain detailed information about your databases.

More information .

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

mysqlbinlog is a client tool which is called mariadb-binlog now. It can still be accessed under its original name via a symlink in Linux, or an alternate binary in Windows.

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

mysql is a simple SQL shell with GNU readline capabilities.

_{This page is licensed: GPLv2}

mariadb-conv is a character set conversion utility for MariaDB.

Usage

mariadb-embedded is a [mariadb client](../mariadb-client/mariadb-command line-client.md), statically linked to libmariadbd, the embedded server.

Previously, the client was called mysql_embedded. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

Upon execution, an embedded MariaDB server is instantiated, and you can execute statements just as you would using the normal mariadb client, using the same options.

resolve_stack_dump is a tool that resolves numeric stack strace dumps into symbols.

Usage

The symbols-file should include the output from: nm --numeric-sort mariadbd. The numeric-dump-file should contain a numeric stack trace from mariadbd. If the numeric-dump-file is not given, the stack trace is read from stdin.

is an open-source database GUI available for Linux, MacOS, and Windows.

Beekeeper Studio works with MariaDB, but also works with other databases.

Beekeeper Studio includes the following features:

• Tabbed interface.

• SSH tunneling.

is a monitoring tool that gives database administrators real-time insights for optimizing the performance of MariaDB servers.

Key Features:

1. Agentless monitoring.

2. Fully customizable.

3. Affordable.

Webyog’s SQL DM is fully compatible with Amazon Aurora databases, and Webyog is an Amazon launch partner.

is a Windows application (which works fine under Wine on Linux) for database design, development, maintenance and testing for several database systems, including MySQL and MariaDB.

With Database Workbench you can:

• design a database;

• connect to multiple databases;

• view and modify meta data;

is a GUI data modeling tool that allows developers to visualize, design, and model databases by using entity relationship diagrams and automatically generate the most popular SQL databases, and to generate and share the data model documentation. Optimize your data model by using advanced features such as test data generation, schema compare, and schema synchronization.

Supported DBMS include MariaDB, MySQL, and Microsoft SQL Server.

Key features:

• Visual data modeling.

• Forward and Reverse Engineering.

is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports many popular relational databases like MySQL, MariaDB, and PostgreSQL.

A list of basic features:

• Data viewer and editor: sorting, filtering, image displaying, export of selected data and much more.

• Metadata browser: possibility to view and edit existing tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions, etc), security entities (users, roles, etc).

is a database design tool for MariaDB and other relational databases.

Draw diagrams, reverse engineer existing database structures and generate SQL code.

Supported platforms include MariaDB, PostgreSQL, and SQLite.

Key features:

• Database modeling & schema design.

• Reverse engineering.

is a graphical frontend for MariaDB. It is a commercial product with several different versions (Navicat Premium, Navicat for MySQL, etc...) and different "editions" within those versions (Non-commercial, Standard, and Enterprise). Certain features are only available in certain editions/versions.

Navicat is available for Windows, MacOS, and Linux.

In addition to standard client features, it includes

• An SQL Builder/Editor,

• A Data Modeling Tool (Enterprise version only),

The Ocelot GUI (ocelotgui), a database client, allows to connect to a MySQL or MariaDB server, enter SQL statements, and receive results. Features include syntax highlighting, user-settable colors and fonts for each part of the screen, resultset displays with multiline rows and resizable columns, and a debugger.

Visit for more information and to download.

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

Querious is a database administration tool for macOS.

It can be purchased and downloaded at .

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

is a fully native database client for macOS and . It supports database management systems such as MariaDB, MySQL, and Postgres.

Features include:

• Syntax highlighting & Autocomplete (sometimes called intellisense).

• Customizable themes allowing the query editor to be completely customized.

SQLyog is a GUI tool to manage MySQL and MariaDB servers and databases in physical, virtual, and cloud environments. DBAs, developers, and database architects alike, use SQLyog to visually compare, optimize, and document schemas.

Key Features:

• Automatically synchronize data,

• Visually compare data, and

• Import external data.

Additional Highlights:

is a graphical front end for MariaDB with a free version, and a Pro version that adds advanced features.

Free Valentina Studio offers the following features:

• natively available on macOS, Windows & Linux,

• a feature rich, visual SQL Editor with powerful search functionality,

• SQLDIFF,

mariadb-find-rows reads files containing SQL statements and extracts statements that match a given regular expression or that contain USE db_name or SET statements.

Previously, the client was called mysql_find_rows. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

The utility was written for use with update log files (as used prior to MySQL 5.0), and as such expects statements to be terminated with semicolon (;) characters. It may be useful with other files that contain SQL statements, as long as statements are terminated with semicolons.

Usage

Each file_name argument should be the name of file containing SQL statements. If no file names are given, the tool reads from stdin (standard input).

Options

mariadb-find-rows supports the following options:

Examples

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

mariadb_waitpid is a utility for terminating processes.

Previously, the client was called mysql_waitpid. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

Usage

Description

mariadb-waitpid sends signal 0 to the process pid and waits up to time seconds for the process to terminate. pid. time must be positive integers.

Returns 0 if the process terminates in time or does not exist, and 1 otherwise.

Signal 1 is used if the kill() system call cannot handle signal 0.

Options

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

my_print_defaults displays the options from option groups of option files. It is useful to see which options a particular tool will use.

Output is one option per line, displayed in the form in which they would be specified on the command line.

Usage

my_print_defaults [OPTIONS] [groups]

Options

Examples

reads from the [mariadb-check] and [client] sections in , so the following would display the mariadb-check options.

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

Description

The replace utility program changes strings in place in files or on the standard input. Invoke replace in one of the following ways:

from represents a string to look for, and to represents its replacement. There can be one or more pairs of strings.

A from-string can contain these special characters:

Use the -- option to indicate where the string-replacement list ends and the file names begin. Any file named on the command line is modified in place, so you may want to make a copy of the original before converting it. replace prints a message indicating which of the input files it actually modifies.

If the -- option is not given, replace reads standard input and writes to stdout (standard output).

replace uses a finite state machine to match longer strings first. It can be used to swap strings. For example, the following command swaps "a" and "b" in the given files, file1 and file2:

Options

replace supports the following options:

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

dbForge Edge is a versatile software solution designed to meet the needs of full-stack database specialists. It offers a wide range of features to address database challenges across major providers: MySQL/MariaDB, SQL Server, Oracle, and PostgreSQL. When it comes to MySQL and MariaDB, dbForge Edge provides a highly functional IDE that covers almost all aspects of database development and management.

Features are described in the following.

Design

dbForge Edge includes a built-in Database Designer equipped with ER diagrams, allowing users to construct and edit databases. An intuitive interface facilitates the creation of database structures and generation of reusable SQL scripts for creating actual databases. Table Designer is a separate feature for visual creation and management of tables that covers the setup of columns, data types, constraints, etc.

SQL Development

dbForge Edge offers a powerful set of features to simplify SQL coding tasks. The code assistance module offers context-based keyword and object suggestions, code completion, instant syntax validation, customizable code formatting profiles, debugging, and code refactoring capabilities. Another feature worth mentioning is Query Builder – a tool that allows users to construct even the most complex SQL queries effortlessly in a visual mode.

Database Management

The solution incorporates schema and data comparison tools, enabling users to identify and manage differences in database schemas and table data. With automatically generated synchronization scripts, changes can be seamlessly deployed to target platforms. Comparison and synchronization jobs can also be automated, improving user efficiency.

dbForge Edge supports data migration (import and export) in over 10 major data formats. Both the import and export processes can be tailored to meet any specific requirements and automated for efficient workflows.

Also, dbForge Edge delivers Source Control, an integrated tool that enables version control of database schemas and static data, available for MariaDB, MySQL, and SQL Server databases. With its help, users can compare database versions, commit and revert changes with dependency awareness, view and resolve conflicts, and examine the history of changes. Source Control supports all popular version control systems, such as Git (including GitHub, GitLab, Azure DevOps, and Bitbucket), Apache Subversion (SVN), TFVC, Mercurial (Hg), Perforce (P4), and SourceGear Vault.

Testing

The solution features a robust Data Generator capable of producing high-quality test data in varying volumes and formats. Additionally, the Query Profiler tool enables comprehensive analysis and optimization of queries, thereby saving valuable time and resources.

Security Management

The dedicated module deals with user management configurations. The functionality provided by the software allows easy creation, editing, and management of user accounts and privileges.

Documenting and Reporting

With dbForge Edge, users can create detailed database documentation in various formats and with convenient navigation. The reporting module enables the summarization and analysis of data, presenting comprehensive reports with informative graphs, diagrams, and pivot tables.

dbForge Edge is not just a comprehensive IDE for MySQL and MariaDB. It also serves as an all-in-one solution for database experts who work with multiple database management systems, eliminating the need to assemble toolsets for each. With its extensive feature set, dbForge Edge empowers professionals to efficiently perform their tasks across diverse database environments.

.

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

DeZign for Databases is a data modeling tool for developers and DBA's that helps model, create, and maintain MariaDB databases. It runs on Windows only.

Supported database management systems include MariaDB, MySQL, and SQL Server.

Key features:

• Visual database modeling (Entity relationship diagrams).

• Generate database schemas directly from the data model.

• Incorporate changes from live databases into your existing models.

• Create change scripts by comparing your model with the live database structure.

• Publish and maintain data definitions to ensure consistency and accessibility.

• Convert models into SQL, streamlining database creation.

• Create clear and visually appealing ER diagrams, including sub-diagrams for complex systems.

• Support version control to manage different iterations of your model.

See for more information.

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

Overview

KS DB Merge Tools for MySQL and MariaDB is a diff & merge tool for MySQL and MariaDB, allowing to compare and sync both schema and data. It is a Freemium application - many features are exposed in the Free version (available for commercial use), some extended features are available only in the paid Standard version (in many cases can be provided at no cost for open source developers).

Product home page

Download

Use cases

Documentation

Application has tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks. Here are the primary application tabs:

Home Tab

It is a starting point to open databases. Shows summary about all database objects. Note that it does not provide information about data/content changes, only about object definitions.

This tab is also used as a starting point to manage diff profiles, making it easy to customize the tool for your specific database project. Here, you can save and reuse custom queries, mappings, and data slices, allowing you to create tailored data diff summaries.

Object List

Lists all objects of some particular type - tables, views, etc. Allows to identify whether some object is new, changed or unchanged (note that for tables and views it does not provide information about data/content changes, only about object definitions). Quick filters available to show only new/changed/new+changed objects. Here we can select required objects on one side and generate a synchronization script to merge these changes to the other side.

Table Data Diff

Compares data for particular table or view. Quick filters available to show only new, changed, or new and changed rows. We can select required rows on one side and generate synchronization script to merge these changes to the other side.

Text Diff

Compares definition of some particular database programming object like view or stored procedure.

Table Structure Diff

Compares definition of particular table. Here we can select required changes and generate synchronization script for them. This tab is available only in the Standard version, the Free version is using Text diff tab to compare table definitions.

Batch Data Diff

Allows to compare data for multiple tables and views, providing summary of data changes for the whole database. This tab is available only in the Standard version.

Query Result Diff

Compares arbitrary query results, it can be the same query running on both databases or different queries running on the same or different databases. This tab is available only in the Standard version.

Automation and Scripting

The Standard version has support of own domain-specific scripting language designed to automate diff and merge tasks provided by GUI. In addition to the primary GUI, there is a Script Editor application designed to help in writing and troubleshooting scripts and a separate command line utility that is used to run these scripts without user interaction. For the most typical tasks the scripts can be generated just with a single button click on GUI which produces a script relevant for the data or objects you currently observe on UI.

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

TablePlus is an application with a clean user interface that allows developers to simultaneously manage databases in a very fast and secure way. It supports many popular database management systems like MariaDB, MySQL, and Postgres.

TablePlus is is available for macOS, Windows, iOS, and Linux.

Some notable features:

• Native build.

• Convenient query editor.

• Multi Tabs & Code Review.

• Can connect to multiples databases simultaneously.

TablePlus is available for free, but users can purchase a license to remove some limitations and customize the tool for higher needs on .

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

resolveip is a utility for resolving IP addresses to host names and vice versa.

Usage

resolveip [OPTIONS] hostname or IP-address

Options

Examples

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

mariadb-fix-extensions converts the extensions for MyISAM (or ISAM) table files to their canonical forms.

It looks for files with extensions matching any lettercase variant of .frm, .myd, .myi, .isd, and .ism and renames them to have extensions of .frm, .MYD, .MYI, .ISD, and .ISM, respectively. This can be useful after transferring the files from a system with case-insensitive file names (such as Windows) to a system with case-sensitive file names.

Invoke mariadb-fix-extensions as follows, where data_dir is the path name to the MariaDB data directory:

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

innochecksum is a tool for printing checksums for InnoDB files.

Usage

Description

The tool reads an tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the integrity of tablespace files after power outages, but can also be used after file copies. Because checksum mismatches causes InnoDB to deliberately shut down a running server, it can be preferable to use innochecksum rather than waiting for a server in production usage to encounter damaged pages.

mariadb-tzinfo-to-sql is a tool used to load on systems that have a zoneinfo database to load the time zone tables (, , , and ) into the mysql database.

Previously, the client was called mysql_tzinfo_to_sql. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

Most Linux, Mac OS X, FreeBSD and Solaris systems will have a zoneinfo database - Windows does not. The database is commonly found in the /usr/share/zoneinfo directory, or, on Solaris, the /usr/share/lib/zoneinfo directory.

is a useful tool for the MariaDB database that allows for the automatic generation of database documentation in such formats as HTML, PDF, and Markdown. Users can adjust the created documentation with a great variety of options.

Features are described in the following.

Searchable MariaDB & MySQL Documentation

Search as you type. View the highlighted matching text after entering the name of a required object in the search field.

Overview

The MariaDB server's is a set of files containing "events" which represent modifications to the contents of a MariaDB database.

mariadb-dumpslow is a tool to examine the .

It parses the slow query log files, printing a summary result. Normally, mariadb-dumpslow groups queries that are similar, except for the particular values of number and string data values. It “abstracts” these values to N and ´S´ when displaying summary output. The -a and -n

mariadb-convert-table-format converts the tables in a database to use a particular storage engine ( by default).

Sometimes you need to work when your computer is busy running . The mariadb-test-run.pl script allows you to stop it temporarily so you can use your computer and then restart the tests when you're ready.

There are two ways to enable this:

1. Command-line: The --stop-file and--stop-keep-alive options.

2. Environment Variables: If you are calling mariadb-test-run.pl indirectly (i.e from a script or program such as buildbot) you can setMTR_STOP_FILE and MTR_STOP_KEEP_ALIVE

myisamchk's performance can be dramatically enhanced for larger tables by making sure that its memory-related variables are set to an optimum level.

By default, myisamchk will use very little memory (about 3MB is allocated), but can temporarily use a lot of disk space. If disk space is a limitation when repairing, the --safe-recover option should be used instead of --recover. However, if TMPDIR points to a memory file system, an out of memory error can easily be caused, as myisamchk places temporary files in TMPDIR. The --tmpdir=path option should be used in this case to specify a directory on disk.

myisamchk has the following requirements for disk space:

• When repairing, space for twice the size of the data file, available in the same directory as the original file. This is for the original file as well as a copy. This space is not required if the --quick option is used, in which case only the index file is re-created.

When testing the S3 storage engine with the s3 test suite, needs access to Amazon S3 compatible storage.

The easiest way to achieve this is to install , an open source S3 compatible storage.

Here is a shell script that you can use to install MinIO with the right credentials for . This should work on most Linux systems as the binaries are statically linked. You can alternatively download MinIO binaries directly from .

Now you can run the S3 test suite:

If there is an issue while running the test suite, you can see the files created by MinIO with:

or

If you want to use MinIO with different credentials or you want to run the test against another S3 storage you ave to update the update the following files:

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

OmniDB is a browser-based tool that simplifies MariaDB database management focusing on interactivity. It is designed to be powerful and lightweight.

Characteristics:

• Browser-based Tool: Accessible from any platform, using a browser as a medium.

• Responsive Interface: All available functions in a single page.

• Unified workspace: Different technologies managed in a single workspace.

aria_read_log is a tool for displaying and applying log records from an Aria transaction log.

Usage

As an option, you need to use at least one of -d or -a.

Options

The following variables can be set while passed as command line options to aria_read_log, or set in the [aria_read_log] section in your file.

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

dbForge Data Compare helps compare and synchronize data in MariaDB, MySQL, and Percona databases and scripts folders. You can find differences between your data, as it helps analyze comparison results, creates a synchronization script, and applies changes. Additionally, MariaDB data can be compared with command-line support.

Features are described in the following.

Database Synchronization Features

• Create accurate synchronization scripts.

• Synchronize asynchronous data.

• Create custom scripts with execution before/after the process of data synchronization.

• Get warning messages on errors during synchronization.

MySQL & MariaDB Task Automation

• Automate routine synchronizations with a command line interface.

• Plan routine execution with Windows Scheduler.

• Support for PowerShell compatibility.

Script for Folder Data Comparison

• Compare data from your database with the data placed in the script folder locally.

• Choose any database, connection, or script folder with the new Data Comparison Wizard.

• See the data comparison results in a data result grid.

Configurations for Data Comparison

• Various options for automatic mapping.

• Compare customized queries.

• Compare custom keys.

Supported Data

• Tables.

• Temporal tables.

• Views.

• BLOB data.

Compatibility Options

• All popular MariaDB server versions.

• MariaDB setup on Windows, Linux, FreeBSD, etc.

• Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud.

• Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona security connections.

Manage Comparison Results

• Find tables by name.

• Filter the comparison process results.

• Enter the values of default comparison options.

• Group records by type in each compared object.

Export Comparison Results

• Use only relevant data in your reports.

• Generate comparison reports in various formats.

Download a free 30-day trial of dbForge Data Compare .

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

dbForge Query Builder is a visual tool that helps create any sort of MariaDB queries. Queries can be drawn on a diagram.

Features are described in the following.

Exporting Data

Export data to many popular formats.

Export data from several tables simultaneously.

Create templates for repeated operations.

Database Explorer

Work with multiple database connections.

MariaDB query management with drag&drop functionality.

Quick script generation.

Visual Drag and Drop Query Builder

Zooming and keyboard support in a sophisticated diagram.

Preview and print diagrams.

Add and edit sub-queries visually.

MariaDB JOINs generator.

SQL Editing and Execution

Check the syntax automatically.

Get quick information about schema objects.

Customize formatting profiles.

Execute scripts, statements and MariaDB fragments seamlessly.

Query Profiler

Compare the results of the query visually.

Review and evaluate a query plan shown in the tree view.

Get the detailed query information.

Data Editor

Advanced data filters.

Browse and edit large objects in Data Viewer and Editor windows.

Fetch asynchronous data.

Data Reports

Data Report wizard supports building Data Reports and customizing them with a rich set of controls.

Master-Detail Browser

Allows users to view and analyze the data of several related database objects in a master-detail structured document. Edit data, build relationships, filter data based on specific criteria, sort data, etc. in the Design and Data views.

Pivot Tables

Let users manipulate data visually, including sorting, grouping, or filtering fields, building charts, and calculating totals.

Download a free 30-day trial of dbForge Query Builder for MariaDB .

is available, too.

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

dbForge Schema Compare is a solution that allows for the comparison of the MariaDB database structure. With this tool, you can find the differences in MariaDB database schemas.

Features are described in the following.

MariaDB & MySQL Schema Synchronization

Update MariaDB schemas by generating accurate synchronization scripts.

Preview sync scripts for any schema objects.

Customize the synchronization output with various options.

Get warnings on possible errors while synchronization.

Sync asynchronous structure.

MariaDB Backup and Restore

Use the advantages of MariaDB backup and restore Wizards.

Create a full or partial backup.

Restore database and schedule backups with a command line interface.

Support for databases over 2Gb.

Scripts Folder Comparison

Compare the data both in two different databases and the database data with the data placed locally.

Choose any connection and script folder stored locally with the new Data Comparison Wizard.

View the comparison process results in a data grid.

Routine Tasks Automation

Sync and compare database schemas with command line support.

Use the Windows Scheduler to automate the sync processes.

Run synchronization and schema comparison tasks with command line execution files.

Supported Schema Objects

Packages.

Sequences.

Database Structure Comparison Configuration

Filter the types of objects before the comparison.

Dismiss particular table options while comparing.

Use the Schema Comparison Wizard for switching between the Target and Source databases.

Comparison Results Analysis

Sort and filter the compared objects.

Get a clear view of MariaDB and MySQL schema diffs in the grid.

Manage groups of compared objects.

Comparison Results Export

Generate comparison results reports in HTML, Excel XML, XML for Excel.

Include specifically selected objects in your comparison report.

Compatibility

All MariaDB instances set up on Windows, Linux, FreeBSD, etc.

Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud.

Security connections: Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona.

Download a free 30-day trial of dbForge MariaDB and MySQL Schema Compare .

is available, too.

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

Startup Option --connect-timeout

This can be used to set the MYSQL_OPT_CONNECT_TIMEOUT parameter of mysql_options, to change the number of seconds before an unsuccessful connection attempt times out.

Test Commands for Handling Warnings During Prepare Statements

• enable_prepare_warnings;

• disable_prepare_warnings;

Normally, when running with the prepared statement protocol with warnings enabled and executing a statement that returns a result set (like SELECT), warnings that occur during the execute phase are shown, but warnings that occur during the prepare phase are ''not'' shown. The reason for this is that some warnings are returned both during prepare and execute; if both copies of warnings were shown, then test cases would show different number of warnings between prepared statement execution and normal execution (where there is no prepare phase).

The enable_prepare_warnings command changes this so that warnings from both the prepare and execute phase are shown, regardless of whether the statement produces a result set in the execute phase. Thedisable_prepare_warnings command reverts to the default behaviour.

These commands only have effect when running with the prepared statement protocol (--ps-protocol) and with warnings enabled (enable_warnings). Furthermore, they only have effects for statements that return a result set (as for statements without result sets, warnings from are always shown when warnings are enabled).

The replace_regex command supports paired delimiters (like in perl, etc). If the first non-space character in the replace_regex argument is one of (, [, {, <, then the pattern should end with ), ], }, > accordingly. The replacement string can use its own pair of delimiters, not necessarily the same as the pattern. If the first non-space character in the replace_regex argument is not one of the above, then it should also separate the pattern and the replacement string and it should end the replacement string. Backslash can be used to escape the current terminating character as usual. The examples below demonstrate valid usage of replace_regex

Dumping "exec" output on errors only

Sometimes it is only interesting to see the output of a utility to stdout/stderr, if utility failed. In case of success , the output might be unpredictable, and contain timestamps, startup messages etc. mariadb-backup can be a good example of such utility.

mysqltest in MariaDB can helps in this situation. In the example below, the output of $XTRABACKUP is suppressed, however if exec fails, stdout and stderr both is dumped , to aid diagnostics:

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

mariadb-plugin is a tool for enabling or disabling .

The client was previously called mysql_plugin, and can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

It is a command line alternative to the and statements, and the --plugin-load option to .

mariadb-plugin must be run while the server is offline, and works by adding or removing rows from the table.

mariadb-plugin basically has two use cases:

aria_pack is a tool for compressing tables. The resulting tables are read-only, and usually about 40% to 70% smaller.

aria_pack is run as follows:

The file name is the .MAI index file. The extension can be omitted, although keeping it permits wildcards, for instance to compress all the files, such as:

aria_pack compresses each column separately. This means, when the resulting data is read, only the individual rows and columns required need to be decompressed, allowing for quicker reading.

Once a table has been packed, use (the quick and recover options) to rebuild its indexes.

mariadb-hotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses , , and cp or scp to make a database backup.

It is a fast way to make a backup of the database or single tables, but it can be run only on the same machine where the database directories are located. mariadb-hotcopy works only for backing up and tables. It runs on Unix and NetWare.

To use

is a powerful solution that helps create massive volumes of meaningful and realistic data. This tool performs various predefined data generators with customizable options.

Data Generator Key Features:

1. Extensive support for all column data types

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

MariaDB Direct Query Adapter is a Microsoft certified connector for Microsoft Power BI Desktop.

About

Microsoft Power BI Desktop is a free business intelligence tool available as a downloadable desktop client. Built for analysts, Microsoft Power BI provides state-of-the-art interactive visualizations, with industry-leading data query and modeling built-in. It is one of the top business intelligence tools in use globally.

MariaDB database products support analytics and data warehousing in addition to transactional databases. Customers can meet the challenges from complex workloads using a single stack. MariaDB Enterprise Server includes pluggable smart storage engines to meet specific workload needs and connectors for high-performance data access by applications.

is a modern SQL editor database management toolkit.

PgManage supports MariaDB along many other databases.

Features:

Desktop or Browser-based: Runs as desktop application or can be installed as a webapp and used in a browser.

Modern Interface: The UI is optimized to be easy to use efficient to navigate.

Multiple Workspaces: Work with many database sessions at once and easily switch between them

Description

mariadb-secure-installation is a shell script available on Unix systems, and enables you to improve the security of your MariaDB installation in the following ways:

• You can set a password for root accounts.

• You can remove root accounts that are accessible from outside the local host.

• You can remove anonymous-user accounts.

• You can remove the test database, which by default can be accessed by anonymous users.

mariadb-secure-installation can be invoked without arguments:

The script will prompt you to determine which actions to perform.

Options

mariadb-secure-installation accepts some options:

Other unrecognized options is passed on to the server.

Option Files

In addition to reading options from the command line, mariadb-secure-installation can also read options from . If an unknown option is provided to mariadb-secure-installation in an option file, it is ignored.

The following options relate to how MariaDB command-line tools handle option files. They must be given as the first argument on the command line:

Option Groups

mariadb-secure-installation reads options from the following from :

Use With Galera Cluster

You should run this script on the first node in the cluster before adding more nodes.

If you want to run this after the cluster is up and running, you should find alternative ways.

Anyone can vote for this to be fixed at .

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

HeidiSQL is a Windows client for MariaDB and MySQL, and is bundled with the Windows version of MariaDB.

HeidiSQL can:

• Connect to multiple servers in one window.

• Connect to servers via command line.

• Create and edit tables, views, stored routines, triggers and scheduled events.

• Generate nice SQL-exports.

More information, including are available at the .

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

mariadb-stress-test is a symlink to mysql-stress-test, the script for assisting with adding users or databases or changing passwords in MariaDB.

mariadb-stress-test.pl is a Perl script that performs stress-testing of the MariaDB server. It requires a version of Perl that has been built with threads support.

Syntax

Options

CC BY-SA / Gnu FDL

mariadb-report makes a friendly report of important MariaDB status values.

Previously, the client was called mysqlreport. It can still be accessed under this name, via a symlink in Linux, or an alternate binary in Windows.

mariadb-report makes a report of nearly every status value from . Unlike SHOW STATUS , which simply dumps over 100 values to the screen in one long list, mariadb-report interprets and formats the values, and presents the basic values and many more inferred values in a human-readable format. Numerous example reports are available in this report: , .

The benefit of mariadb-report is that it allows you to very quickly see a wide array of performance indicators for your MariaDB server which would otherwise need to be calculated by hand from all the various SHOW STATUS values. For example, the Index Read Ratio is an important value but it's not present in

is an open source RDBMS (relational database management system) frontend tool to create and manage various databases.

Preparing the ODBC Connection

First, make sure to prepare MariaDB Connector/ODBC as explained in .

This includes

• downloading ,

perror is a utility that displays descriptions for system or storage engine error codes.

See for a full list of MariaDB error codes, and for a list of Linux and Windows error codes.

Usage

If you need to describe a negative error code, use -- before the first error code to end the options.