Managing Users and Privileges - Learning MySQL - page 320

Another method to check current privileges is to use SQL to explore the mysql database
that manages the privileges. If you're experienced with SQL, this is perhaps the easiest
approach, and it's the one we usually use. We describe this approach later in “Managing
Privileges with SQL.”
mysqlaccess
To quickly see what level of access a particular user has for a particular database, you
can use the mysqlaccess script from a terminal or command prompt. Let's see what
level of access the user partmusic has for the database music . We'll need to specify the
MySQL superuser name ( root ) and password to access the information:
$ mysqlaccess --user=root --password= the_mysql_root_password partmusic music
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier ([e-mail])
Changes by Steve Harvey ([e-mail])
This software comes with ABSOLUTELY NO WARRANTY.
Access-rights
for USER 'partmusic', from HOST 'localhost', to DB 'music'
+-----------------------+---+ +----------------------+---+
| Select_priv | N | | Lock_tables_priv | N |
| Insert_priv | N | | Execute_priv | N |
| Update_priv | N | | Repl_slave_priv | N |
| Delete_priv | N | | Repl_client_priv | N |
| Create_priv | N | | Create_view_priv | N |
| Drop_priv | N | | Show_view_priv | N |
| Reload_priv | N | | Create_routine_priv | N |
| Shutdown_priv | N | | Alter_routine_priv | N |
| Process_priv | N | | Create_user_priv | N |
| File_priv | N | | Ssl_type | ? |
| Grant_priv | N | | Ssl_cipher | ? |
| References_priv | N | | X509_issuer | ? |
| Index_priv | N | | X509_subject | ? |
| Alter_priv | N | | Max_questions | 0 |
| Show_db_priv | N | | Max_updates | 0 |
| Super_priv | N | | Max_connections | 0 |
| Create_tmp_table_priv | N | | Max_user_connections | 0 |
+-----------------------+---+ +----------------------+---+
NOTE: A password is required for user `partmusic' :-(
The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in db-table.'
user : 'localhost','partmusic','652f9c175d1914f9',
'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
'N','N','N','N','N','N','N','N','N','','','','','0','0','0','0'
BUGs can be reported by email to [e-mail]
If you specify the wildcard character '*' in place of music , the access privileges for all
databases will be shown. Similarly, you can specify the wildcard character '*' in place