---
name: "mariadb-access"
section: "1"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mariadb-access"
---

# mariadb-access(1)

client for checking access privileges (mariadb-access is now a symlink to mariadb-access)

## NAME

mariadb-access - client for checking access privileges (mariadb-access is now a symlink to mariadb-access)

## SYNOPSIS

**mariadb-access \[***host\_name* **\[***user\_name* **\[***db\_name***\]\]\] \[***options***\]**

## DESCRIPTION

**mariadb-access** is a diagnostic tool written by Yves Carlier. It checks the access privileges for a host name, user name, and database combination. Note that **mariadb-access** checks access using only the user, db, and host tables. It does not check table, column, or routine privileges specified in the tables\_priv, columns\_priv, or procs\_priv tables.

Invoke **mariadb-access** like this:

```
shell> mariadb-access [host_name [user_name [db_name]]] [options]
```

**mariadb-access** supports the following options.

• **--help**, **-?**

Display a help message and exit.

• **--brief**, **-b**

Generate reports in single-line tabular format.

• **--commit**

Copy the new access privileges from the temporary tables to the original grant tables. The grant tables must be flushed for the new privileges to take effect. (For example, execute a **mariadb-admin reload** command.)

• **--copy**

Reload the temporary grant tables from original ones.

• **--db=***db\_name*, **-d** *db\_name*

Specify the database name.

• **--debug=***N*

Specify the debug level. *N* can be an integer from 0 to 3.

• **--host=***host\_name*, **-h** *host\_name*

The host name to use in the access privileges.

• **--howto**

Display some examples that show how to use **mariadb-access**.

• **--old\_server**

Connect to a very old MySQL server (before MySQL 3.21) that does not know how to handle full WHERE clauses.

• **--password\[=***password***\]**, **-p\[***password***\]**

The password to use when connecting to the server. If you omit the *password* value following the **--password** or **-p** option on the command line, **mariadb-access** prompts for one.

Specifying a password on the command line should be considered insecure. See Section 5.3.2.2, “End-User Guidelines for Password Security”.

• **--plan**

Display suggestions and ideas for future releases.

• **--preview**

Show the privilege differences after making changes to the temporary grant tables.

• **--relnotes**

Display the release notes.

• **--rhost=***host\_name*, **-H** *host\_name*

Connect to the MariaDB server on the given host.

• **--rollback**

Undo the most recent changes to the temporary grant tables.

• **--spassword\[=***password***\]**, **-P\[***password***\]**

The password to use when connecting to the server as the superuser. If you omit the *password* value following the **--spassword** or **-p** option on the command line, **mariadb-access** prompts for one.

Specifying a password on the command line should be considered insecure. See Section 5.3.2.2, “End-User Guidelines for Password Security”.

• **--superuser=***user\_name*, **-U** *user\_name*

Specify the user name for connecting as the superuser.

• **--table**, **-t**

Generate reports in table format.

• **--user=***user\_name*, **-u** *user\_name*

The user name to use in the access privileges.

• **--version**, **-v**

Display version information and exit.

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:

```
$MYSQL     = '/usr/local/bin/mariadb';    # path to mariadb executable
```

Change the path to reflect the location where **mariadb** actually is stored on your system. If you do not do this, a Broken pipe error will occur when you run **mariadb-access**.

## COPYRIGHT

Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2025 MariaDB Foundation

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see http://www.gnu.org/licenses/.

## SEE ALSO

For more information, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/

## AUTHOR

MariaDB Foundation (http://www.mariadb.org/).