Checking Privileges | 321

| 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 bugs@mysql.com
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 whereto 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.

Download 4.24 Mb.

Share with your friends: