mariadb-access

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

Current

The client tool can alternatively be called by its former name, mysqlaccess, via a symlink in Linux, or an alternate binary in Windows.

< 10.5

The client tool is called mysqlaccess.

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

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.

Usage

mariadb-access [host [user [db]]] OPTIONS

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 the mariadb client tool is stored on your system. Otherwise, a Broken pipe error occurs when running mariadb-access.

Options

Option	Description
-?, --help	Display help and exit.
-v, --version	Display version.
-u username, --user=username	Username for logging in to the server.
-p[password], --password[=password]	Password to use for user. If omitted, mariadb-access prompts for one.
-h hostname, --host=hostname	Name or IP of the host.
-d dbname, --db=dbname	Name of the database.
-U username, --superuser=username	Connect as superuser.
-P password, --spassword=password	Password for superuser.
-H server, --rhost=server	Remote server to connect to.
--old_server	Connect to a very old MySQL servers (before version 3.21) that does not know how to handle full WHERE clauses.
-b, --brief	Single-line tabular report.
-t, --table	Report in table-format.
--relnotes	Print release-notes.
--plan	Print suggestions/ideas for future releases.
--howto	Some examples of how to run `mariadb-access'.
--debug=N	Enter debug level N (0..3).
--copy	Reload temporary grant tables from original ones.
--preview	Show differences in privileges after making changes in (temporary) grant tables.
--commit	Copy grant rules from temporary tables to grant tables (the grant tables must be flushed afterwards, for example with mariadb-admin reload).
--rollback	Undo the last changes to the grant tables.

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}