mysqlaccess(1)

NAME

       mysqlaccess - client for checking access privileges

SYNOPSIS

       mysqlaccess [host_name [user_name [db_name]]] [options]

DESCRIPTION

       mysqlaccess is a diagnostic tool that Yves Carlier has
       provided for the MySQL distribution. It checks the access
       privileges for a hostname, username, 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.

       Invoke mysqlaccess like this:

       shell> mysqlaccess [host_name [user_name [db_name]]] [options]

       mysqlaccess understands the following options:

       o  --help, -?

          Display a help message and exit.

       o  --brief, -b

          Generate reports in single-line tabular format.

       o  --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 mysqladmin reload command.)

       o  --copy

          Reload the temporary grant tables from original ones.

       o  --db=db_name, -d db_name

          Specify the database name.

       o  --debug=N

          Specify the debug level.  N can be an integer from 0 to
          3.

       o  --host=host_name, -h host_name

          The hostname to use in the access privileges.

       o  --howto

          Display some examples that show how to use mysqlaccess.

       o  --old_server

          Assume that the server is an old MySQL server (before
          MySQL 3.21) that does not yet know how to handle full
          WHERE clauses.

       o  --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, you are prompted for
          one.

          Specifying a password on the command line should be
          considered insecure. See Section 7.6, "Keeping Your
          Password Secure".

       o  --plan

          Display suggestions and ideas for future releases.

       o  --preview

          Show the privilege differences after making changes to
          the temporary grant tables.

       o  --relnotes

          Display the release notes.

       o  --rhost=host_name, -H host_name

          Connect to the MySQL server on the given host.

       o  --rollback

          Undo the most recent changes to the temporary grant
          tables.

       o  --spassword[=password], -P[password]

          The password to use when connecting to the server as
          the superuser. If you omit the password value following
          the --password or -p option on the command line, you
          are prompted for one.

          Specifying a password on the command line should be
          considered insecure. See Section 7.6, "Keeping Your
          Password Secure".

       o  --superuser=user_name, -U user_name

          Specify the username for connecting as the superuser.

       o  --table, -t

          Generate reports in table format.

       o  --user=user_name, -u user_name

          The username to use in the access privileges.

       o  --version, -v

          Display version information and exit.

       If your MySQL 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:

       $MYSQL     = '/usr/local/bin/mysql';    # path to mysql executable

       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.

SEE ALSO

       msql2mysql(1), myisamchk(1), myisamlog(1), myisampack(1),
       mysql(1), mysql.server(1), mysql_config(1),
       mysql_fix_privilege_tables(1), mysql_upgrade(1),
       mysql_zap(1), mysqladmin(1), mysqlbinlog(1),
       mysqlcheck(1), mysqld(1), mysqld_multi(1), mysqld_safe(1),
       mysqldump(1), mysqlhotcopy(1), mysqlimport(1),
       mysqlmanager(1), mysqlshow(1), perror(1), replace(1),
       safe_mysqld(1)

       For more information, please refer to the MySQL Reference
       Manual, which may already be installed locally and which
       is also available online at http://dev.mysql.com/doc/.

AUTHOR

       MySQL AB (http://www.mysql.com/).  This software comes
       with no warranty.

MySQL 5.0                   03/04/2006         FBMYSQLACCESSFR(1)