W3cubDocs

/MariaDB

mysqlaccess

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

It checks the access privileges for a host name, user name, and database combination. Note that mysqlaccess 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.

From MariaDB 10.4.6, mariadb-access is a symlink to mysqlaccess.

Usage

mysqlaccess [host [user [db]]] OPTIONS

If your MariaDB distribution is installed in some non-standard location, you must change the location where mysqlaccess expects to find the mysql client. Edit the mysqlaccess script at approximately line 18. Search for a line that looks like this: <<code> $MYSQL = ´/usr/local/bin/mysql´; # path to mysql executable <</code>> Change the path to reflect the location where mysql actually is stored on your system. If you do not do this, a Broken pipe error will occur when you run mysqlaccess.

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, mysqlaccess 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 `mysqlaccess'.
--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 mysqladmin 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 '*')

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqlaccess/