Managing Users and Privileges - Learning MySQL - page 322

| 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 |
+-----------------------+---+ +----------------------+---+
BEWARE: Everybody can access your DB as user `ANY_NEW_USER' from host `localhost'
: WITHOUT supplying a password.
: Be very careful about it!!
BEWARE: Accessing the db as an anonymous user.
: Your username has no relevance
The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in db-table.'
user : 'localhost','','','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]
You can also check the results for all hosts by executing mysqlaccess '*' '*' '*' . Note
that mysqlaccess shows only database-level access and not finer-grained privileges such
as table- or column-level access. For this level of information, you must use SHOW
GRANTS or direct SQL access to the mysql database.
Configuring mysqlaccess
The mysqlaccess program is a Perl script; if you're using Windows, you'll need to follow
the instructions in “Installing Perl modules under Windows” in Chapter 2 to be able
to use Perl scripts.
A common problem occurs when mysqlaccess doesn't know where to find your MySQL
directories. If you've installed MySQL in a nonstandard location, you may get an error
message saying that the script couldn't find the MySQL client program. To resolve this
problem, you'll need to provide the correct path to the mysql executable. Find the
mysqlaccess file in the MySQL bin directory, open it in a text editor, find the line that
sets the $MYSQL variable, and modify it to specify the correct path for your MySQL
installation.
For example, you might find the path set to /usr/bin/mysql as below:
$MYSQL = '/usr/bin/mysql'; # path to mysql executable
If you've installed MySQL in /usr/local/mysql , you would change this to:
$MYSQL = '/usr/local/mysql/bin/mysql'; # path to mysql executable
Now save the file and exit the editor; hopefully, everything should work now.