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


* * *