2
.\" Title: \fBmysqlaccess\fR
3
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
6
.\" Manual: MySQL Database System
10
.TH "\FBMYSQLACCESS\FR" "1" "03/01/2010" "MySQL 5\&.1" "MySQL Database System"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
23
mysqlaccess \- client for checking access privileges
25
.HP \w'\fBmysqlaccess\ [\fR\fB\fIhost_name\fR\fR\fB\ [\fR\fB\fIuser_name\fR\fR\fB\ [\fR\fB\fIdb_name\fR\fR\fB]]]\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
26
\fBmysqlaccess [\fR\fB\fIhost_name\fR\fR\fB [\fR\fB\fIuser_name\fR\fR\fB [\fR\fB\fIdb_name\fR\fR\fB]]] [\fR\fB\fIoptions\fR\fR\fB]\fR
30
is a diagnostic tool that Yves Carlier has provided for the MySQL distribution\&. It checks the access privileges for a host name, user name, and database combination\&. Note that
32
checks access using only the
36
tables\&. It does not check table, column, or routine privileges specified in the
50
shell> \fBmysqlaccess [\fR\fB\fIhost_name\fR\fR\fB [\fR\fB\fIuser_name\fR\fR\fB [\fR\fB\fIdb_name\fR\fR\fB]]] [\fR\fB\fIoptions\fR\fR\fB]\fR
57
supports the following options\&.
67
.\" mysqlaccess: help option
68
.\" help option: mysqlaccess
72
Display a help message and exit\&.
83
.\" mysqlaccess: brief option
84
.\" brief option: mysqlaccess
88
Generate reports in single\-line tabular format\&.
99
.\" mysqlaccess: commit option
100
.\" commit option: mysqlaccess
103
Copy the new access privileges from the temporary tables to the original grant tables\&. The grant tables must be flushed for the new privileges to take effect\&. (For example, execute a
104
\fBmysqladmin reload\fR
116
.\" mysqlaccess: copy option
117
.\" copy option: mysqlaccess
120
Reload the temporary grant tables from original ones\&.
131
.\" mysqlaccess: db option
132
.\" db option: mysqlaccess
133
\fB\-\-db=\fR\fB\fIdb_name\fR\fR,
134
\fB\-d \fR\fB\fIdb_name\fR\fR
136
Specify the database name\&.
147
.\" mysqlaccess: debug option
148
.\" debug option: mysqlaccess
149
\fB\-\-debug=\fR\fB\fIN\fR\fR
151
Specify the debug level\&.
153
can be an integer from 0 to 3\&.
164
.\" mysqlaccess: host option
165
.\" host option: mysqlaccess
166
\fB\-\-host=\fR\fB\fIhost_name\fR\fR,
167
\fB\-h \fR\fB\fIhost_name\fR\fR
169
The host name to use in the access privileges\&.
180
.\" mysqlaccess: howto option
181
.\" howto option: mysqlaccess
184
Display some examples that show how to use
196
.\" mysqlaccess: old_server option
197
.\" old_server option: mysqlaccess
200
Assume that the server is an old MySQL server (before MySQL 3\&.21) that does not yet know how to handle full
213
.\" mysqlaccess: password option
214
.\" password option: mysqlaccess
215
\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
216
\fB\-p[\fR\fB\fIpassword\fR\fR\fB]\fR
218
The password to use when connecting to the server\&. If you omit the
224
option on the command line,
228
Specifying a password on the command line should be considered insecure\&. See
229
Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
240
.\" mysqlaccess: plan option
241
.\" plan option: mysqlaccess
244
Display suggestions and ideas for future releases\&.
255
.\" mysqlaccess: preview option
256
.\" preview option: mysqlaccess
259
Show the privilege differences after making changes to the temporary grant tables\&.
270
.\" mysqlaccess: relnotes option
271
.\" relnotes option: mysqlaccess
274
Display the release notes\&.
285
.\" mysqlaccess: rhost option
286
.\" rhost option: mysqlaccess
287
\fB\-\-rhost=\fR\fB\fIhost_name\fR\fR,
288
\fB\-H \fR\fB\fIhost_name\fR\fR
290
Connect to the MySQL server on the given host\&.
301
.\" mysqlaccess: rollback option
302
.\" rollback option: mysqlaccess
305
Undo the most recent changes to the temporary grant tables\&.
316
.\" mysqlaccess: spassword option
317
.\" spassword option: mysqlaccess
318
\fB\-\-spassword[=\fR\fB\fIpassword\fR\fR\fB]\fR,
319
\fB\-P[\fR\fB\fIpassword\fR\fR\fB]\fR
321
The password to use when connecting to the server as the superuser\&. If you omit the
327
option on the command line,
331
Specifying a password on the command line should be considered insecure\&. See
332
Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
343
.\" mysqlaccess: superuser option
344
.\" superuser option: mysqlaccess
345
\fB\-\-superuser=\fR\fB\fIuser_name\fR\fR,
346
\fB\-U \fR\fB\fIuser_name\fR\fR
348
Specify the user name for connecting as the superuser\&.
359
.\" mysqlaccess: table option
360
.\" table option: mysqlaccess
364
Generate reports in table format\&.
375
.\" mysqlaccess: user option
376
.\" user option: mysqlaccess
377
\fB\-\-user=\fR\fB\fIuser_name\fR\fR,
378
\fB\-u \fR\fB\fIuser_name\fR\fR
380
The user name to use in the access privileges\&.
391
.\" mysqlaccess: version option
392
.\" version option: mysqlaccess
396
Display version information and exit\&.
399
If your MySQL distribution is installed in some nonstandard location, you must change the location where
405
script at approximately line 18\&. Search for a line that looks like this:
411
$MYSQL = \'/usr/local/bin/mysql\'; # path to mysql executable
417
Change the path to reflect the location where
419
actually is stored on your system\&. If you do not do this, a
421
error will occur when you run
426
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
428
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
430
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
432
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
435
For more information, please refer to the MySQL Reference Manual,
436
which may already be installed locally and which is also available
437
online at http://dev.mysql.com/doc/.
439
Sun Microsystems, Inc. (http://www.mysql.com/).