mysqlaccess

This script allows you to connect to a server, retrieve access privilege information, and test the result of specifying user privileges. It does this using copies of the user, db, and host tables from the mysql database. (mysqlaccess cannot be used to experiment with table or column privileges, however.) You can also commit changes you make to the temporary tables back into the actual tables in the mysql database.

To use mysqlaccess, you must have sufficient privileges to access the grant tables yourself.

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

Standard Options Supported by mysqlaccess
--host --password --user --version

Options Specific to mysqlaccess
--brief, -b

Display results in single-line format.

--commit

Copy the temporary grant tables back to the mysql database. Be sure to execute a mysqladmin flush-privileges command afterward so that the server notices the changes.

--copy

Load the grant tables into the temporary tables.

--db=db_name, -d db_name

The database name.

--debug=n

Specify the debugging level. n should be an integer from 0 to 3, with higher values producing greater amounts of diagnostic output.

--howto

Display some examples demonstrating how to use mysqlaccess.

--old_server

Use this option when the server is older than MySQL 3.21; it causes mysqlaccess to make certain adjustments to the queries that it sends to the server.

--plan

Display a list of enhancements planned for future releases of mysqlaccess.

--preview

Display the privilege differences between the actual and temporary grant tables.

--relnotes

Print the mysqlaccess release notes.

--rhost=host_name, -H host_name

The remote server host to connect to.

--rollback

Undo the changes made to the temporary grant tables.

--spassword=pass_val, -P pass_val

The password for the MySQL superuser (a user with sufficient privileges to modify the grant tables).

--superuser=user_name, -U user_name

The username for the MySQL superuser.

--table, -t

Display results in tabular format.