The mysqlaccess script provides information that can be useful in detect problems with user access to a given database. However before you process for this script you should make sure that you must always do a ‘mysqladmin reload’ after making changes to the MySQL database tables.

Mysqlaccess script support the following option. You may use either the “short” single character or more verbose versions.

-?, –help Display help message.
-v, –version Print version information.
-u, –user=… Username to use for logging into database.
-p, –password=… Password to use for logging into database. Note there can be no space between the -p and the password.
-h, –host=… Name of host to use for host permissions check.
-d, –db=… Name of database to use for database permissions check.
-U, –superuser=… Name of superuser account.
-P, –spassword=… Password for the superuser account.
-b, –brief Print single-line tabular report.
–relnotes Print release notes
–plan Print suggestions/ideas for future releases
–howto Print examples of how to run `mysqlaccess’
–debug=N Enter debuglevel N (0..3)

You should note that you need to also specify the user and db you would like to check. If no host is given, it would be assumed as ‘localhost’.