FreeBSD Manual Pages
MARIADB-ACCESS(1) MariaDB Database System MARIADB-ACCESS(1) 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 origi- nal grant tables. The grant tables must be flushed for the new privi- leges to take effect. (For example, execute a mariadb-admin reload com- mand.) * --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 inse- cure. 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 inse- cure. 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 mari- adb 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/). MariaDB 11.8 5 March 2025 MARIADB-ACCESS(1)
NAME | SYNOPSIS | DESCRIPTION | COPYRIGHT | SEE ALSO | AUTHOR
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mysqlaccess&sektion=1&manpath=FreeBSD+Ports+15.1.quarterly>