Contents

  1. Usage
  2. Options
  3. Note

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.

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

OptionDescription
-?, --helpDisplayhelp and exit.
-v, --versionDisplay version.
-u username, --user=usernameUsername 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=dbnameName of the database.
-U username, --superuser=usernameConnect as superuser.
-P password, --spassword=passwordPassword for superuser.
-H server, --rhost=serverRemote server to connect to.
--old_serverConnect to a very old MySQL servers (before version 3.21) that does not know how to handle full WHERE clauses.
-b, --briefSingle-line tabular report.
-t, --tableReport in table-format.
--relnotesPrint release-notes.
--planPrint suggestions/ideas for future releases.
--howtoSome examples of how to run `mysqlaccess'.
--debug=NEnter debug level N (0..3).
--copyReload temporary grant-tables from original ones.
--previewShow differences in privileges after making changes in (temporary) grant-tables.
--commitCopy grant-rules from temporary tables to grant-tables (the grant tables must be flushed after, for example with mysqladmin reload).
--rollbackUndo 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 '*')

Comments

Comments loading...