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.
From MariaDB 10.5.2, mariadb-access is the name of the tool, with mysqlaccess a symlink .
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 '*')
