mariadb-access
mariadb-access is a tool for checking access privileges, developed by Yves Carlier.
MariaDB starting with 10.4.6
From MariaDB 10.4.6, mariadb-access is a symlink to mysqlaccess.
MariaDB starting with 10.5.2
From MariaDB 10.5.2, mariadb-access is the name of the tool, with mysqlaccess a symlink.
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.
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: <<code> $MYSQL = ´/usr/local/bin/mariadb; # path to mariadb executable <</code>> 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.
Options
| Option | Description |
|---|---|
-?, --help | Displayhelp and exit. |
-v, --version | Display version. |
-u username, --user=username | Username for logging in to the db. |
-p[password], --password[=password] | Password to use for user. If ommitted, 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 after, 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) must be given, even with wildcards. If no host is provided, `localhost' is assumed. Wildcards (*,?,%,_) are allowed for host, user and db, but be sure to escape them from your shell!! (ie type \* or '*')
