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}

innochecksum is a tool for printing checksums for InnoDB files.

Usage

innochecksum [options] file_name

Description

The tool reads an InnoDB 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.

innochecksum works with compressed pages, and includes options to analyze leaf pages to estimate how fragmented an index is and how much benefit can be gained from defragmentation.

Options

innochecksum supports the following options. For options that refer to page numbers, the numbers are zero-based.

Examples

Rewriting a CRC32 checksum to replace an invalid checksum:

innochecksum --no-check --write crc32 tablename.ibd

A count of each page type:

innochecksum --page-type-summary data/mysql/gtid_slave_pos.ibd

File::data/mysql/gtid_slave_pos.ibd
================PAGE TYPE SUMMARY==============
#PAGE_COUNT	PAGE_TYPE
===============================================
       1	Index page
       0	Undo log page
       1	Inode page
       0	Insert buffer free list page
       2	Freshly allocated page
       1	Insert buffer bitmap
       0	System page
       0	Transaction system page
       1	File Space Header
       0	Extent descriptor page
       0	BLOB page
       0	Compressed BLOB page
       0	Page compressed page
       0	Page compressed encrypted page
       0	Other type of page

===============================================
Additional information:
Undo page type: 0 insert, 0 update, 0 other
Undo page state: 0 active, 0 cached, 0 to_free, 0 to_purge, 0 prepared, 0 other
index_id	#pages		#leaf_pages	#recs_per_page	#bytes_per_page
24		1		1		0		0

index_id	page_data_bytes_histgram(empty,...,oversized)
24		1	0	0	0	0	0	0	0	0	0	0	0

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

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}

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.

Examples

Sending options with --server-arg:

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

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}

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.

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 .

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

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}

mysqlbinlog is a client tool which is called 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}

Querious is a database administration tool for macOS.

It can be purchased and downloaded at .

_{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

my_print_defaults --defaults-file=example.cnf client client-server mysql

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

my_print_defaults mariadb-check client

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

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

See MariaDB Error Codes for a full list of MariaDB error codes, and Operating System Error Codes for a list of Linux and Windows error codes.

Usage

perror [OPTIONS] [ERRORCODE [ERRORCODE...]]

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

Options

Examples

System error code:

shell> perror 96
OS error code  96:  Protocol family not supported

MariaDB/MySQL error code:

shell> perror 1005 1006
MySQL error code 1005 (ER_CANT_CREATE_TABLE): Can't create table %`s.%`s (errno: %M)
MySQL error code 1006 (ER_CANT_CREATE_DB): Can't create database '%-.192s' (errno: %M)

shell> perror --silent 1979
You are not owner of query %lu

_{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:

shell> replace from to [from to] ... -- file_name [file_name] ...
shell> replace from to [from to] ... < file_name

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:

shell> replace a b b a -- file1 file2 ...

Options

replace supports the following options:

_{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

mariadb-waitpid [options] pid time

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}

ERBuilder Data Modeler 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.

• Data Model Validation.

• Data model documentation.

• Schema Comparison and Synchronization.

• Test data generation.

• Change Database Platform.

• Generate web user interface for CRUD.

• Version management.

A feature-limited free version is available for download. Advanced features are available in the commercial edition. A feature comparison matrix is available for more details about features, pricing, and trial versions.

See www.soft-builder.com for more information.

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

Luna Modeler 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.

• Support for database-specific settings.

• Three display modes: metadata, sample data or descriptions.

• Default values for newly created objects.

• Export to PDF.

• Dark and Light themes.

• SQL script generation.

Supported OS

Luna Modeler is available for Windows, Linux and macOS.

More information

See www.datensen.com for more information.

_{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.

• Simplified Editing: Easy to add and remove connections.

• Safety: Multi-user support with encrypted personal information.

• Interactive Tables: All functionalities use interactive tables, allowing copying and pasting in blocks.

• Smart SQL Editor: Contextual SQL code completion.

• Beautiful SQL Editor: You can choose between many available color themes.

• Tabbed SQL Editor: Easily add, rename or delete editor tabs.

More information can be found here.

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

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

Usage

resolve_stack_dump [OPTIONS] symbols-file [numeric-dump-file]

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.

Options

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

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}

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 ocelot.ca for more information and to download.

_{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}

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:

• Runs on Microsoft Windows with no dependencies on runtimes (such as Microsoft .NET and Java) and database abstraction layers (such as ODBC and JDBC).

• Distributed as a free Community edition and as a paid, proprietary Ultimate edition.

More information can be found here.

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

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.

• SQL autocomplete.

• Multi-connection.

The Community Edition is , and is , with no usage tracking or similar behavior.

Links

• Homepage -

• GitHub -

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

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}

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.

• The ability to run multiple queries at one time (and a customizable run query shortcut).

• Improved query error detection (errors in queries is underlined red).

• Full dark mode & light mode support, along with custom themes.

Other features include:

• Complete SSH Tunnel support.

• Inline data filtering.

• Exporting & Exporting options to CSV, JSON & XML.

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

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

Secure: Sensitive information like DB passwords, SSH keys etc. is stored in an encrypted form and protected by Master Password.

Schema and Table Editors: Create/alter tables and manage data using intuitive and clean UI.

Smart SQL Editor: Context-aware code completion, error annotations, powerful search and replace.

Light or Dark: Different themes to choose from.

Tabbed Workspace: Keep multiple editors and other tools open and easily switch between them.

Quick Search: Easily find an object in DB Explorer using a fuzzy search dialog.

Tunneling: Connect to your databases via SSH tunnel if it is not directly accessible.

Links:

Product Page Github Project

_{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}

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.

Keep Alive

If you plan on using this feature with other programs, such as buildbot, you should set the MTR_STOP_KEEP_ALIVE environment variable or the --stop-keep-alive command line option with a value in seconds. This will make the script print messages to whatever program is calling mariadb-test-run.pl at the interval you set to prevent timeouts.

If you are calling mariadb-test-run.pl directly, you do not need to specify a timeout.

The mariadb-test-run Stop File

The stop file is a temporary file that you create on your system when you want to pause the execution of mariadb-test-run. When enabled via the command line or environment variable options, mariadb-test-run will periodically check for the existence of the file and if it exists it will stop until the file is no longer present.

Examples

Command-line:

Environment Variables:

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

mariadb-fix-extensions converts the extensions for (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}

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 options can be used to modify value abstracting behavior.

Usage

Options

-a

Don't abstract all numbers to N and strings to 'S'.

-d, --debug

Debug mode.

-g PATTERN

Grep: only consider statements that include this string.

--help

Display help.

-h HOSTNAME

Hostname of db server for -slow.log filename (can be wildcard), default is '', i.e. match all.

-i NAME

Name of server instance (if using mysql.server startup script).

-l

Don't subtract lock time from total time.

-n NUM

Abstract numbers with at least NUM digits within names.

-r

Reverse the sort order (largest last instead of first).

-s ORDER

What to sort by (aa, ae, al, ar, at, a, c, e, l, r, t). at is default. aa average rows affected ae aggregated number of rows examined al average lock time ar average rows sent at average query time a rows affected c count e rows examined l lock time r rows sent t query time.

-t NUM

Just show the top NUM queries.

-v, --verbose

Verbose mode.

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

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

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 for that!

See Also

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

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

Usage

Options

Examples

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

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.

Features specifically for RDS and Aurora instances also available. SQL Diagnostic Manager is browser based and is a proud MariaDB Monitor and Advisor.

SQLyog Ultimate is a MySQL administration tool for DBAs, developers, and database architects. This tool enables database developers, administrators, and architects to visually compare, optimize, and document schemas.

Key Features:

1. Automatically synchronize data.

2. Visually compare data.

3. Import external data.

SQLyog runs on Windows and is a graphical MariaDB manager and admin tool, combining the features of MySQL Administrator, phpMyAdmin and other MariaDB frontend tools.

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

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.

• Disk space in the temporary directory (TMPDIR or the tmpdir=path option) is needed for sorting if the --recover or --sort-recover options are used when not using --safe-recover). The space required is approximately (largest_key + row_pointer_length) * number_of_rows * 2. To get information about the length of the keys as well as the row pointer length, use myisamchk -dv table_name.

• Space for a new index file to replace the existing one. The old index is first truncated, so unless the old index file is not present or is smaller for some reason, no significant extra space is needed.

There are a number of that are useful to adjust when running myisamchk. They will increase memory usage, and since some are per-session variables, you don't want to increase the general value, but you can either pass an increased value to myisamchk as a command line option, or with a [myisamchk] section in your file.

• . By default this is 4M, but it's very useful to increase to make myisamchk sorting much faster. Since the server won't be running when you run myisamchk, you can increase substantially. 16M is usually a minimum, but values such as 256M are not uncommon if memory is available.

• (which particularly helps with the --extend-check and --safe-recover options.

For example, if you have more than 512MB available to allocate to the process, the following settings could be used:

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

dbForge Documenter 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.

Compatibility Options

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.

Database Structure

Detailed MariaDB database information, such as types, details, and properties of the objects, inter-object dependencies, and DDL codes.

Customization of Document Management

Various style templates allowing for alteration of documentation layout.

Document Formats

• HTML and PDF (searchable formats).

• Markdown.

Extended Properties Support

Edit or add an object description.

Download a free 30-day trial of dbForge Documenter for MariaDB and MySQL here.

Documentation is available, too.

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

mariadb-tzinfo-to-sql is a tool used to load time zones on systems that have a zoneinfo database to load the time zone tables (time_zone, time_zone_leap_second, time_zone_name, time_zone_transition and time_zone_transition_type) 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.

Usage

mariadb-tzinfo-to-sql can be called in several ways. The output is usually passed straight to the mariadb client for direct loading in the mysql database.

shell> mariadb-tzinfo-to-sql timezone_dir
shell> mariadb-tzinfo-to-sql timezone_file timezone_name
shell> mariadb-tzinfo-to-sql --leap timezone_file

Resetting timezone tables

If there is a need to reset the timezone to the default, to before using mariadb-tzinfo-to-sql, one can do that by executing:

TRUNCATE TABLE mysql.time_zone;
TRUNCATE TABLE mysql.time_zone_name;
TRUNCATE TABLE mysql.time_zone_transition;
TRUNCATE TABLE mysql.time_zone_transition_type;
TRUNCATE TABLE mysql.time_zone_leap_second;

The old timezone values is in effect until the server is restarted.

Examples

Most commonly, the whole directory is passed:

shell> mariadb-tzinfo-to-sql /usr/share/zoneinfo | mariadb -u root mysql

Load a single time zone file, timezone_file, corresponding to the time zone called timezone_name :

shell> mariadb-tzinfo-to-sql timezone_file timezone_name | mariadb -u root mysql

A separate command for each time zone and time zone file the server needs is required.

To account for leap seconds, use:

shell> mariadb-tzinfo-to-sql --leap timezone_file | mariadb -u root mysql

After populating the time zone tables, you should usually restart the server so that the new time zone data are correctly loaded.

_{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}

Navicat 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),

• Data/Structure Synchronization,

• Report Builder (Windows-only),

• "Premium" version which can connect to MariaDB, MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases simultaneously.

A feature comparison matrix is available. More information, including pricing and trial versions, is available on the Navicat website.

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

Valentina Studio 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,

• a highly productive Data Editor,

• support for many data sources,

• ODBC import,

• Schema Editor with powerful visual diagramming features, Diagram Editor; import diagrams from MySQL Workbench,

• Report Viewer with printing, export to PDF and HTML (local reports and from Valentina Server),

• Forms Client for working with visual forms and MariaDB (locally and from Valentina Server),

• Free supports most popular data sources, MariaDB, MySQL, SQL Server, SQLite, PostgreSQL and more.

Use the Valentina Studio FREE vs Valentina Studio PRO feature matrix to see which version is best for your needs or download to immediately evaluate.

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

Overview

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

Events are written in a binary (that is, non-human-readable) format. The mariadb-binlog utility is used to view these events in plain text.

Run mariadb-binlog from a command line:

mariadb-binlog [options] binlog-filename [binlog-filename ...]

See mariadb-binlog Options for details on the available options.

Usage

Display the contents of a binary log file named mariadb-bin.000152 like this:

mariadb-binlog mariadb-bin.000152

Processing a Single Log File

The logging format is determined by the value of the binlog_format system variable. If you are using statement-based logging, the output includes the SQL statement, the ID of the server the statement was executed on, a timestamp, and how much time the statement took to execute. If you are using row-based logging, the output of an event will not include an SQL statement, but will instead output how individual rows were changed.

The output from mariadb-binlog can be used as input to the mariadb client to redo the statements contained in a binary log. This is useful for recovering after a server crash (replace binlog-filename with the name of a binary log file):

mariadb-binlog binlog-filename | mysql -u root -p

If you would like to view and possibly edit the file before applying it to your database, use the -r flag to redirect the output to a file (replace outputfile with the name of a file to store the output, and binlog-filename with the name of a binary log file):

mariadb-binlog -r outputfile binlog-filename

In the output file, delete any statements you don't want executed (such as an accidental DROP DATABASE). Once you are satisfied with the contents, you can execute it:

mariadb -u root -p --binary-mode < outputfilename

Be careful to process multiple log files in a single connection, especially if one or more of them have any CREATE TEMPORARY TABLE ... statements. Temporary tables are dropped when the mariadb client terminates, so if you are processing multiple log files one at a time (i.e. multiple connections), and one log file creates a temporary table and then a subsequent log file refers to the table, you get an 'unknown table' error.

Processing Multiple Log Files

To execute multiple log files using a single connection, list them all on the mariadb-binlog command line:

mariadb-binlog mariadb-bin.000001 mariadb-bin.000002 | mariadb -u root -p --binary-mode

If you need to manually edit the binlogs before executing them, combine them all into a single file before processing:

mariadb-binlog mariadb-bin.000001 > /tmp/mariadb-bin.sql
mariadb-binlog mariadb-bin.000002 >> /tmp/mariadb-bin.sql
# make any edits
mariadb -u root -p -e "source /tmp/mariadb-bin.sql"

See Also

• mariadb-binlog

• mariadb-binlog Options

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 www.datanamic.com for more information.

_{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.

• All features.

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

Syntax

mariadb-setpermission [options]

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 can help you add users or databases or change passwords in MariaDB.

It interactively sets permissions in the MariaDB grant tables, but does not check permissions which have already been set in MariaDB. So if you can't connect to MariaDB using the permission you just added, take a look at the permissions which have already been set in MariaDB.

The account used when you connect determines which permissions you have when attempting to modify existing permissions in the grant tables.

mariadb-setpermission also reads options from the [client] and [perl] groups in the .my.cnf file in your home directory, if the file exists.

The following options are available:

Options

Example

./mariadb-setpermission --user=msandbox --password=msandbox --host=127.0.0.1 --port=11200
######################################################################
## Welcome to the permission setter 1.4 for MariaDB.
## made by Luuk de Boer
######################################################################
What would you like to do:
  1. Set password for an existing user.
  2. Create a database + user privilege for that database
     and host combination (user can only do SELECT)
  3. Create/append user privilege for an existing database
     and host combination (user can only do SELECT)
  4. Create/append broader user privileges for an existing
     database and host combination
     (user can do SELECT,INSERT,UPDATE,DELETE)
  5. Create/append quite extended user privileges for an
     existing database and host combination (user can do
     SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
     LOCK TABLES,CREATE TEMPORARY TABLES)
  6. Create/append full privileges for an existing database
     and host combination (user has FULL privilege)
  7. Remove all privileges for an existing database and
     host combination.
     (user will have all permission fields set to N)
  0. exit this program

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

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.

• Compare databases and sync different MariaDB versions.

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}

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

Enjoy the advantage of various data types support

2. Multiple generators with unique test data

Enjoy multiple customization options with individual generators for every data type supported

3. MariaDB data generation and data integrity support

Generate consistent random data through multiple tables

Disable triggers and constraints to avoid interference with database logic

4. MariaDB data distribution modes

Fine-tune the way you want your data to be generated

5. Multiple ways to generate data in MySQL

Generate a data population script, execute it against a MariaDB database, save or edit it later

6. Basic generators

Populate tables with a great variety of values types, like JSON, Python, XML, etc.

7. Meaningful test data generators

Select any of 200+ real-world generators and populate tables with realistic data related to various spheres

8. User-defined generators

Create, save and use your own data generators tailored for your needs

9. Real-time data generation preview

Enjoy real-time visualization of the alterations you make

Visually assess the data to be generated

10. Command-line interface

Schedule your routine data generation tasks

Create a command line execution file for running database documentation tasks

11. Broad compatibility options

MariaDB server versions 5.5-11.4

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 Data Generator .

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

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}

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).

• Data transfer: export and import for files in various formats (CSV, HTML, XML, XLS, XLSX).

• ER diagrams: possibility to automatically generate ER diagrams for a database/schema (diagram will contain all schema tables) or for a single table and export the diagram in a suitable format.

• SQL editor: possibility to organize all your scripts in folders, reassign database connections for particular scripts.

• Data and metadata search: full-text data search using against all chosen tables/views.

• Database structure comparing: possibility to perform objects structure compare.

Usability is the main goal of this project, so the program UI is carefully designed and implemented. Users can send bug report and feature request on the .

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

mysql is a simple SQL shell with GNU readline capabilities.

_{This page is licensed: GPLv2}

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

aria_pack is run as follows:

aria_pack [options] file_name [file_name2...]

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 *.MAI

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 aria_chk -rq (the quick and recover options) to rebuild its indexes.

Options

The following variables can be set as command line options to aria_pack, or set in the [ariapack] section in your my.cnf file:

Unpacking

To unpack a table compressed with aria_pack, use the aria_chk -u option.

Example

> aria_pack /my/data/test/posts
Compressing /my/data/test/posts.MAD: (1690 records)
- Calculating statistics
- Compressing file
37.71%     
> aria_chk -rq --ignore-control-file /my/data/test/posts
- check record delete-chain
- recovering (with keycache) Aria-table '/my/data/test/posts'
Data records: 1690
State updated

See Also

• FLUSH TABLES FOR EXPORT

• myisamchk

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

mariadb-hotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses FLUSH TABLES, LOCK TABLES, 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 MyISAM and ARCHIVE tables. It runs on Unix and NetWare.

To use mariadb-hotcopy, you must have read access to the files for the tables that you are backing up, the SELECT privilege for those tables, the RELOAD privilege (to be able to execute FLUSH TABLES), and the LOCK TABLES privilege (to be able to lock the tables).

shell> mariadb-hotcopy db_name [/path/to/new_directory]
shell> mariadb-hotcopy db_name_1 ... db_name_n /path/to/new_directory

Back up tables in the given database that match a regular expression:

shell> mariadb-hotcopy db_name./regex/

The regular expression for the table name can be negated by prefixing it with a tilde (~):

shell> mariadb-hotcopy db_name./~regex/

mariadb-hotcopy supports the following options, which can be specified on the command line or in the [mariadb-hotcopy] and [client] option file groups.

--help, -?

Display a help message and exit.

--addtodest

Do not rename target directory (if it exists); merely add files to it.

--allowold

Do not abort if a target exists; rename it by adding an _old suffix.

--checkpoint=db_name.tbl_name

Insert checkpoint entries into the specified database db_name and table tbl_name.

--chroot=directory

Base directory of the chroot jail in which mariadbd operates. The path value should match that of the --chroot option given to mariadbd.

--debug

Enable debug output.

--dryrun, -n

Report actions without performing them.

--flushlog

Flush logs after all tables are locked.

--host=host_name, -h host_name

The host name of the local host to use for making a TCP/IP connection to the local server. By default, the connection is made to localhost using a Unix socket file.

--keepold

Do not delete previous (renamed) target when done.

--method=method

The method for copying files (cp or scp). The default is cp.

--noindices

Do not include full index files for MyISAM tables in the backup. This makes the backup smaller and faster. The indexes for reloaded tables can be reconstructed later with myisamchk -rq.

--old-server

Connect to old MySQL server (before MySQL 5.5) which doesn't have FLUSH TABLES WITH READ LOCK fully implemented.

--password=password, -ppassword

The password to use when connecting to the server. The password value is mandatory for this option, unlike for other MariaDB programs. Specifying a password on the command line should be considered insecure. You can use an option file to avoid giving the password on the command line.

--port=port-number, -P port-number

The TCP/IP port number to use when connecting to the local server.

--quiet, -q

Be silent except for errors.

--record\_log\_pos=db_name.tbl_name

Record master and slave status in the specified database db_name and table tbl_name.

--regexp=expression

Copy all databases with names that match the given regular expression.

--resetmaster

Reset the binary log after locking all the tables.

--resetslave

Reset the master.info file after locking all the tables.

--socket=socket-file, -S socket-file

The Unix socket file to use for connections to localhost.

--suffix=string

The suffix string to use for names of copied databases.

--tmpdir=directory

The temporary directory. The default is /tmp.

--user=username, -u username

The MariaDB username to use when connecting to the server.

Use perldoc for additional mariadb-hotcopy documentation, including information about the structure of the tables needed for the--checkpoint and ``--record_log_pos options:

shell> perldoc mariadb-hotcopy

See Also

• mariadb-dump

• mariadb-backup

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

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

Usage

mariadb-conv [OPTION...] [FILE...]

Options

mariadb-conv supports the following options:

By default, mariadb-conv exits whenever it encounters any conversion problems, like

• the input byte sequence is not valid in the source character set;

• the character cannot be converted to the target character set.

The -c option makes mariadb-conv ignore such errors and use the question mark (?) to replace bytes in bad input sequences, or unconvertible characters.

The --delimiter=... option makes mariadb-conv treat the specified characters as delimiters rather than data to convert, so the input is treated as a combination of

• data chunks, which are converted according to the -f and -t options;

• delimiters, which are not converted and are copied from the input to the output as is.

Examples

Convert the file file.latin1.txt from latin1 to utf8 :

mariadb-conv -f latin1 -t utf8 file.latin1.txt

Convert the file file.latin1.txt from latin1 to utf8, reading the input data from stdin:

mariadb-conv -f latin1 -t utf8 < file.latin1.txt

Using mariadb-conv in a pipe:

echo test | ./mariadb-conv -f utf8 -t ucs2 >file.ucs2.txt

As a side effect, mariadb-conv can be used to list MariaDB data directories in a human readable form. Suppose you create the following tables:

SET NAMES utf8;
CREATE OR REPLACE TABLE t1 (a INT);
CREATE OR REPLACE TABLE ß (a INT);
CREATE OR REPLACE TABLE абв (a INT);
CREATE OR REPLACE TABLE 桌子 (a INT);

This statement creates the following files in the MariaDB data directory:

@1j.frm
@1j.ibd
@684c@5b50.frm
@684c@5b50.ibd
@g0@h0@i0.frm
@g0@h0@i0.ibd
t1.frm
t1.ibd

It's not precisely clear which file stores which table, because MariaDB uses a special table-name-to-file-name encoding.

This command on Linux (assuming an utf-8 console) can print the table list in a readable way:

ls | mariadb-conv -f filename -t utf8 --delimiter=".\n"

ß.frm
ß.ibd
桌子.frm
桌子.ibd
абв.frm
абв.ibd
t1.frm
t1.ibd

Windows users can use the following command to list the data directory in the ANSI text console:

dir /b | mariadb-conv -c -f filename -t cp850 --delimiter=".\r\n"

Note:

• The -t options assume a Western machine.

• The -c option is needed to ignore conversion errors for Cyrillic and CJK characters.

• --delimiter= additionally needs the carriage return character.

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

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:

shell> mariadb-secure-installation

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

Example:
localhost:# mariadb-secure-installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password is blank,
so you should just press enter here.
Enter current password for root (enter for none): 
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
You already have a root password set, so you can safely answer 'n'.
Change the root password? [Y/n] n
 ... skipping.
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
 ... Success!
Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
 ... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
 ... Success!
Cleaning up...
All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!

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 option files. 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 option groups from option files:

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 MDEV-10112.

_{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 here.

Documentation 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 here.

Documentation is available, too.

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

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

Usage

mariadb-convert-table-format [options] db_name

Description

mariadb-convert-table-format is written in Perl and requires that the DBI and DBD::mysql Perl modules be installed. Invoke mariadb-convert-table-format like this:

shell> mariadb-convert-table-format [options]db_name

The db_name argument indicates the database containing the tables to be converted.

Options

mariadb-convert-table-format supports the options described in the following list:

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

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.

• Export from one server/database directly to another server/database.

• Manage user-privileges.

• Import text-files.

• Export table rows as CSV, HTML, XML, SQL, LaTeX and Wiki Markup.

• Browse and edit table-data using a comfortable grid.

• Bulk edit tables (move to db, change engine, collation etc.).

• Batch-insert ascii or binary files into tables.

• Write queries with customizable syntax-highlighting and code-completion.

• Pretty reformat disordered SQL.

• Monitor and kill client-processes.

• Find specific text in all tables of all databases of one server.

• Optimize and repair tables in a batch manner.

More information, including are available at the .

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

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 columnar storage engine designed to handle the extremely large data sets and ad hoc queries of analytical workloads. Data is written to disk by column rather than row and is automatically partitioned. Columnar data storage is designed to deliver real time analysis on billions of rows. MariaDB Enterprise ColumnStore is a plugin storage engine and is included with MariaDB Enterprise Server.

MariaDB Direct Query Adapter enables Power BI users to work with remote data without the need to download it onto the local machine. Downloading analytical data sets can present challenges such as download speed and inadequate memory on a local machine, and even a powerful laptop or desktop is outperformed by the processing power of a high end server or MPP system. MariaDB's Direct Query Adapter enables users to avoid these limitations and provides robust querying and data visualization from any location.

Requirements

MariaDB Direct Query Adapter for Microsoft Power BI requires:

• .

Download and Install

To use MariaDB Direct Query Adapter with Microsoft Power BI Desktop:

1. Check the .

2. Download using the Microsoft instructions.

3. Download .

4. Select MariaDB ODBC Connector v3.1.10 or later for Windows.

5. Click on the download or choose "Open" to start the MariaDB ODBC Connector Setup Wizard.

6. Click "Next".

7. Read and accept the terms and agreement.

8. Click "Next".

9. Choose "Typical" for installation type and click "Install".

10. When asked if you want to allow this app to makes changes to your device, click "Yes".

11. If you have older versions of MariaDB ODBC Connector 64-bit, select "Make User DSN's for older Connector version to use this version" and click "Finish". Otherwise, just click "Finish".

Connect

Connect to your remote MariaDB database from Power BI Desktop using the MariaDB Direct Query Adapter.

1. Open Microsoft Power BI Desktop.

2. From the Power BI home screen, choose Get Data->More. Enter "MariaDB". Select MariaDB from the menu and click "Connect".

3. Enter the data source. This is an IP address and port number, or in the case of MariaDB Cloud, it is the qualified domain name and port number.

4. Select "DirectQuery" and click "OK".

5. Enter your user name and password and click "Connect".

You are now connected to your remote MariaDB database and can use Microsoft Power BI to run queries without the need to download the data locally.

Queries

The MariaDB Direct Query Adapter for Power BI interacts with the SQL layer. It is upstream of the storage engine, so queries can be done regardless of the underlying storage engine.

For example, MariaDB Direct Query Adapter for Microsoft Power BI can be used to query data on a row-based transactional database using the InnoDB storage engines or a column-based data warehouse using the MariaDB Enterprise ColumnStore storage engine to deliver real time analysis of billions of rows of data.

Relationships

Power BI depends on relationships for data analysis. These relationships are automatically established for row-based databases, for example those using the InnoDB storage engine.

Because column-based storage engines such as MariaDB Enterprise ColumnStore do not use indexes, relationships must be set up manually. For more about creating relationships in Power BI see .

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

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:

1. To add a plugin even before the first real server startup.

2. To remove a plugin that crashes the server on startup.

For the installation use case, adding a entry to my.cnf or in a separate include option file is a better alternative. In case of a plugin loaded via a mysql.plugin crashing the server, uninstalling the plugin with the help of mariadb-plugin can be the only viable action, though.

Usage

mariadb-plugin expects to find a configuration file that indicates how to configure the plugins. The configuration file has, by default, the same name as the plugin, with an .ini extension:

Here, mariadb-plugin looks for a file called crazyplugins.ini :

The first line should contain the name of the library object file, with no extension. The other lines list the names of the components. Each value should be on a separate line. The # character at the start of a line indicates a comment.

Options

The following options can be specified on the command line, while some can be specified in the [mysqld] group of any option file. For options specified in a [mysqld] group, only the --basedir, --datadir, and --plugin-dir options can be used — the rest are ignored.

See Also

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

mariadb-find-rows reads files containing SQL statements and extracts statements that match a given regular expression or that contain or 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}

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

Usage

aria_read_log OPTIONS

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 my.cnf file.

_{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

mariadb-stress-test.pl [options]

Options

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.

Learn more about SB Data Generator.

_{This page is licensed: 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 SHOW STATUS. 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: hackmysql.com/mysqlreport, archived here.

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 SHOW STATUS; it's an inferred value (the ratio of Key_reads to Key_read_requests).

This documentation outlines all the command line options in mariadb-report, most of which control which reports are printed. This document does not address how to interpret these reports; that topic is covered in the document Guide To Understanding mysqlreport, archived here.

Usage

mariadb-report [options]

mariadb-report options

Technically, command line options are in the form --option, but -option works, too. All options can be abbreviated if the abbreviation is unique. For example, option --host can be abbreviated to --ho but not --h because --h is ambiguous: it could mean --host or --help.

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

LibreOffice Base 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 the latest MariaDB Connector/ODBC,

• copying the shared library libmaodbc.so to /usr/lib/[multi-arch],

• installing the unixodbc, unixodbc-dev, openssh-client, odbcinst packages, and

• creating a template file for the .

• Install the ODBC driver from the template file by running:

$ sudo odbcinst -i -d -f MariaDB_odbc_driver_template.ini
odbcinst: Driver installed. Usage count increased to 1. 
    Target directory is /etc

Verify the installation was successful in /etc/odbcinst.ini file (this path is obtained by the config info /-j/ option, where drivers are installed in that predefined location).

$ odbcinst -j
unixODBC 2.3.6
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/anel/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

$ cat /etc/odbcinst.ini 
[MariaDB ODBC 3.1 Driver]
Description=MariaDB Connector/ODBC v.3.1
Driver=/usr/lib/x86_64-linux-gnu/libmaodbc.so
UsageCount=1

• Create a template file for the . A sample “MariaDB_odbc_data_source_template.ini” could be:

• Install data source:

odbcinst -i -s -h -f MariaDB_odbc_data_source_template.ini

• Verify successful installation in the /.odbc.ini file

$ cat ~/.odbc.ini 
[MariaDB-server]
Description=MariaDB server
Driver=MariaDB ODBC 3.1 Driver
SERVER=MariaDB
USER=anel
PASSWORD=
DATABASE=test
PORT=3306

• Verify successful installation also using the utility:

$ isql MariaDB-server
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> show tables;
+--------------------------------------------------------------------------+
| Tables_in_test                                                           |
+--------------------------------------------------------------------------+
| Authors                                                                  |
| tbl_names                                                                |
| webposts                                                                 |
| webusers                                                                 |
+--------------------------------------------------------------------------+
SQLRowCount returns 4
4 rows fetched

Start with LibreOffice Base

Start Libreoffice Base from the terminal by running lobase (make sure to install the libreoffice-base package if needed). The default option is to create a new database, which is HSQLDB. In order to connect to a running MariaDB server, choose “Connect to an existing database” and choose “ODBC” driver as shown below:

After that, choose DSN (the one that we created in the previous step) and click “Next”:

Provide a user name (and password if needed) and again check the connection (with the “Test Connection” button) and click “Next”:

After that, we have options to register the database. Registration in this sense means that the database is viewable by other LibreOffice modules (like LibreOffice Calc and LibreOffice Writer). So this step is optional. In this example, we will save as “fosdem21_mariadb.odb”. See Using a Registered Database.

It opens the following window:

It consists of three panels:

1. “Database” window with the options,

2. "Tables",

3. "Queries",

4. "Forms",

5. "Reports".

6. "Tasks window (dependent on what is selected in the “Database” window). When “Tables” is selected, the options are:

7. "Create Table in Design View",

8. "Use Wizard to Create Table" and

9. "Create View".

10. "Tables" window - shows list of tables that are created.

As we can see, there are system tables in the “mysql” database as well as “test” database.

Let’s say we create a table using the REST API from JSON data from posts, and another table using the same mechanism from users, and let’s call them webposts and webusers. In order to do so, we have to enable the CONNECT storage engine plugin and start with REST_API. See more in the CONNECT - Files Retrieved Using Rest Queries article.

The queries we need to run in MariaDB are:

CREATE TABLE webusers ENGINE=CONNECT TABLE_TYPE=JSON
  HTTP='http://jsonplaceholder.typicode.com/users';

CREATE TABLE webposts ENGINE=CONNECT TABLE_TYPE=JSON
  HTTP='http://jsonplaceholder.typicode.com/posts';

The result in LibreOffice Base is as shown below:

Double clicking on the table opens a new window with the data displayed to inspect:

To create the table from the “Tasks” window, use the option “Create Table in Design View”, where one can specify specific field names and types as shown:

From the “Tasks” window one can create a table using the option “Use Wizard to Create Table” to create some sample tables.

One can fill the data in the existing table, or create and define the new table from the LibreOffice Calc module with simple copy-paste (in the "Tasks" window).

Using a Registered Database

Other modules can use the registered database, for example, open "LibreOffice Calc" and go to "Tools", "Options" and you will see the "odb" file we registered when starting "LibreOffice Base".

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

is a universal IDE with GUI tools that has all the necessary built-in capabilities to work with MariaDB and MySQL databases for their development, management, and administration. It allows for creating, managing, and editing the data without the need to store them locally.

This GUI tool offers a rich visual design that is perfect for working with large scripts, preparing data reports, and database projects. At any time, you can back up or restore your data, export or import them to and from the most commonly used formats, and compare or synchronize the MariaDB databases.

Features are described in the following.

Intelligent SQL Coding

• Automatic code completion.

• MariaDB syntax highlighting.

• Code refactoring and formatting.

• CRUD generation.

Database Compare and Sync

• Data and schema synchronization and comparison.

• Recurring database sync tasks planning.

• Comparison report generation.

Import and Export Data

• MariaDB data export to commonly used formats.

• Data import from popular formats into MariaDB table.

• Rich customization ability.

• Command-line automation for data tasks.

MariaDB Administration Tools

• MariaDB databases backing up and restoring.

• User accounts and permissions configuration.

• Table maintenance.

• Database scripts generation.