Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
ab.1	10.3 KB	-rw-r--r--
adacurses.1	2.9 KB	-rw-r--r--
adacurses-config.1	2.9 KB	-rw-r--r--
apxs.1	10.41 KB	-rw-r--r--
aria_chk.1	7.42 KB	-rw-r--r--
aria_dump_log.1	1.46 KB	-rw-r--r--
aria_ftdump.1	732 B	-rw-r--r--
aria_pack.1	2.13 KB	-rw-r--r--
aria_read_log.1	3.17 KB	-rw-r--r--
bison.1	6.26 KB	-rw-r--r--
bzcmp.1	18 B	-rw-r--r--
bzdiff.1	897 B	-rw-r--r--
bzegrep.1	18 B	-rw-r--r--
bzfgrep.1	18 B	-rw-r--r--
bzgrep.1	1.27 KB	-rw-r--r--
bzip2.1	15.88 KB	-rw-r--r--
bzless.1	18 B	-rw-r--r--
bzmore.1	4.21 KB	-rw-r--r--
captoinfo.1m	6.47 KB	-rw-r--r--
clear.1	2.61 KB	-rw-r--r--
dbmmanage.1	5.64 KB	-rw-r--r--
galera_new_cluster.1	995 B	-rw-r--r--
galera_recovery.1	601 B	-rw-r--r--
htdbm.1	9.02 KB	-rw-r--r--
htdigest.1	1.9 KB	-rw-r--r--
htpasswd.1	8.53 KB	-rw-r--r--
httxt2dbm.1	1.68 KB	-rw-r--r--
infocmp.1m	17.01 KB	-rw-r--r--
infotocap.1m	3.56 KB	-rw-r--r--
innochecksum.1	6.37 KB	-rw-r--r--
logresolve.1	1.4 KB	-rw-r--r--
mariabackup.1	582 B	-rw-r--r--
mariadb.1	11 B	-rw-r--r--
mariadb-access.1	17 B	-rw-r--r--
mariadb-admin.1	16 B	-rw-r--r--
mariadb-backup.1	17 B	-rw-r--r--
mariadb-binlog.1	17 B	-rw-r--r--
mariadb-check.1	16 B	-rw-r--r--
mariadb-client-test.1	23 B	-rw-r--r--
mariadb-client-test-embedded.1	32 B	-rw-r--r--
mariadb-convert-table-format.1	32 B	-rw-r--r--
mariadbd-multi.1	18 B	-rw-r--r--
mariadbd-safe.1	17 B	-rw-r--r--
mariadbd-safe-helper.1	24 B	-rw-r--r--
mariadb-dump.1	15 B	-rw-r--r--
mariadb-dumpslow.1	19 B	-rw-r--r--
mariadb-embedded.1	20 B	-rw-r--r--
mariadb-find-rows.1	21 B	-rw-r--r--
mariadb-fix-extensions.1	26 B	-rw-r--r--
mariadb-hotcopy.1	18 B	-rw-r--r--
mariadb-import.1	17 B	-rw-r--r--
mariadb-install-db.1	22 B	-rw-r--r--
mariadb-ldb.1	15 B	-rw-r--r--
mariadb-plugin.1	18 B	-rw-r--r--
mariadb-secure-installation.1	31 B	-rw-r--r--
mariadb-service-convert.1	950 B	-rw-r--r--
mariadb-setpermission.1	25 B	-rw-r--r--
mariadb-show.1	15 B	-rw-r--r--
mariadb-slap.1	15 B	-rw-r--r--
mariadb-test.1	15 B	-rw-r--r--
mariadb-test-embedded.1	24 B	-rw-r--r--
mariadb-tzinfo-to-sql.1	25 B	-rw-r--r--
mariadb-upgrade.1	19 B	-rw-r--r--
mariadb-waitpid.1	19 B	-rw-r--r--
mbstream.1	610 B	-rw-r--r--
msql2mysql.1	2.62 KB	-rw-r--r--
myisamchk.1	49.9 KB	-rw-r--r--
myisam_ftdump.1	5.4 KB	-rw-r--r--
myisamlog.1	4.41 KB	-rw-r--r--
myisampack.1	19.25 KB	-rw-r--r--
my_print_defaults.1	5.5 KB	-rw-r--r--
my_safe_process.1	692 B	-rw-r--r--
mysql.1	60.78 KB	-rw-r--r--
mysqlaccess.1	8.57 KB	-rw-r--r--
mysqladmin.1	25.83 KB	-rw-r--r--
mysqlbinlog.1	46.08 KB	-rw-r--r--
mysqlcheck.1	23.1 KB	-rw-r--r--
mysql_client_test.1	7.74 KB	-rw-r--r--
mysql_client_test_embedded.1	29 B	-rw-r--r--
mysql_config.1	6.13 KB	-rw-r--r--
mysql_convert_table_format.1	5.3 KB	-rw-r--r--
mysqld_multi.1	15.74 KB	-rw-r--r--
mysqld_safe.1	17.49 KB	-rw-r--r--
mysqld_safe_helper.1	563 B	-rw-r--r--
mysqldump.1	58.88 KB	-rw-r--r--
mysqldumpslow.1	5.95 KB	-rw-r--r--
mysql_embedded.1	17 B	-rw-r--r--
mysql_find_rows.1	3.99 KB	-rw-r--r--
mysql_fix_extensions.1	2.43 KB	-rw-r--r--
mysqlhotcopy.1	10.11 KB	-rw-r--r--
mysqlimport.1	17.43 KB	-rw-r--r--
mysql_install_db.1	8.59 KB	-rw-r--r--
mysql_ldb.1	576 B	-rw-r--r--
mysql_plugin.1	9.01 KB	-rw-r--r--
mysql_secure_installation.1	3.71 KB	-rw-r--r--
mysql.server.1	4.87 KB	-rw-r--r--
mysql_setpermission.1	4.37 KB	-rw-r--r--
mysqlshow.1	14.11 KB	-rw-r--r--
mysqlslap.1	22.98 KB	-rw-r--r--
mysql-stress-test.pl.1	10.73 KB	-rw-r--r--
mysqltest.1	20.25 KB	-rw-r--r--
mysqltest_embedded.1	21 B	-rw-r--r--
mysql-test-run.pl.1	49.17 KB	-rw-r--r--
mysql_tzinfo_to_sql.1	3.91 KB	-rw-r--r--
mysql_upgrade.1	15.4 KB	-rw-r--r--
mysql_waitpid.1	3.38 KB	-rw-r--r--
ncurses5-config.1	3.66 KB	-rw-r--r--
perror.1	3.71 KB	-rw-r--r--
replace.1	3.99 KB	-rw-r--r--
reset.1	12.65 KB	-rw-r--r--
resolveip.1	2.81 KB	-rw-r--r--
resolve_stack_dump.1	3.53 KB	-rw-r--r--
sabcmd.1	2.93 KB	-rw-r--r--
tabs.1	5.15 KB	-rw-r--r--
tic.1m	12.22 KB	-rw-r--r--
toe.1m	4.19 KB	-rw-r--r--
tput.1	11.59 KB	-rw-r--r--
tset.1	12.65 KB	-rw-r--r--
wsrep_sst_common.1	655 B	-rw-r--r--
wsrep_sst_mariabackup.1	626 B	-rw-r--r--
wsrep_sst_mysqldump.1	618 B	-rw-r--r--
wsrep_sst_rsync.1	601 B	-rw-r--r--
wsrep_sst_rsync_wan.1	648 B	-rw-r--r--
xmlwf.1	7.71 KB	-rw-r--r--

Code Editor : mysqlaccess.1

'\" t
.\"
.TH "\FBMYSQLACCESS\FR" "1" "28 March 2019" "MariaDB 10\&.4" "MariaDB Database System"
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.\" mysqlaccess
.SH "NAME"
mysqlaccess \- client for checking access privileges
.SH "SYNOPSIS"
.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
\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
.SH "DESCRIPTION"
.PP
\fBmysqlaccess\fR
is a diagnostic tool written by Yves Carlier\&. It checks the access privileges for a host name, user name, and database combination\&. Note that
\fBmysqlaccess\fR
checks access using only the
user,
db, and
host
tables\&. It does not check table, column, or routine privileges specified in the
tables_priv,
columns_priv, or
procs_priv
tables\&.
.PP
Invoke
\fBmysqlaccess\fR
like this:
.sp
.if n \{\
.RS 4
.\}
.nf
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
.fi
.if n \{\
.RE
.\}
.PP
\fBmysqlaccess\fR
supports the following options\&.
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: help option
.\" help option: mysqlaccess
\fB\-\-help\fR,
\fB\-?\fR
.sp
Display a help message and exit\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: brief option
.\" brief option: mysqlaccess
\fB\-\-brief\fR,
\fB\-b\fR
.sp
Generate reports in single\-line tabular format\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: commit option
.\" commit option: mysqlaccess
\fB\-\-commit\fR
.sp
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
\fBmysqladmin reload\fR
command\&.)
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: copy option
.\" copy option: mysqlaccess
\fB\-\-copy\fR
.sp
Reload the temporary grant tables from original ones\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: db option
.\" db option: mysqlaccess
\fB\-\-db=\fR\fB\fIdb_name\fR\fR,
\fB\-d \fR\fB\fIdb_name\fR\fR
.sp
Specify the database name\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: debug option
.\" debug option: mysqlaccess
\fB\-\-debug=\fR\fB\fIN\fR\fR
.sp
Specify the debug level\&.
\fIN\fR
can be an integer from 0 to 3\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: host option
.\" host option: mysqlaccess
\fB\-\-host=\fR\fB\fIhost_name\fR\fR,
\fB\-h \fR\fB\fIhost_name\fR\fR
.sp
The host name to use in the access privileges\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: howto option
.\" howto option: mysqlaccess
\fB\-\-howto\fR
.sp
Display some examples that show how to use
\fBmysqlaccess\fR\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: old_server option
.\" old_server option: mysqlaccess
\fB\-\-old_server\fR
.sp
Connect to a very old MySQL server (before MySQL 3\&.21) that does not know how to handle full
WHERE clauses\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: password option
.\" password option: mysqlaccess
\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR,
\fB\-p[\fR\fB\fIpassword\fR\fR\fB]\fR
.sp
The password to use when connecting to the server\&. If you omit the
\fIpassword\fR
value following the
\fB\-\-password\fR
or
\fB\-p\fR
option on the command line,
\fBmysqlaccess\fR
prompts for one\&.
.sp
Specifying a password on the command line should be considered insecure\&. See
Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: plan option
.\" plan option: mysqlaccess
\fB\-\-plan\fR
.sp
Display suggestions and ideas for future releases\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: preview option
.\" preview option: mysqlaccess
\fB\-\-preview\fR
.sp
Show the privilege differences after making changes to the temporary grant tables\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: relnotes option
.\" relnotes option: mysqlaccess
\fB\-\-relnotes\fR
.sp
Display the release notes\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: rhost option
.\" rhost option: mysqlaccess
\fB\-\-rhost=\fR\fB\fIhost_name\fR\fR,
\fB\-H \fR\fB\fIhost_name\fR\fR
.sp
Connect to the MariaDB server on the given host\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: rollback option
.\" rollback option: mysqlaccess
\fB\-\-rollback\fR
.sp
Undo the most recent changes to the temporary grant tables\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: spassword option
.\" spassword option: mysqlaccess
\fB\-\-spassword[=\fR\fB\fIpassword\fR\fR\fB]\fR,
\fB\-P[\fR\fB\fIpassword\fR\fR\fB]\fR
.sp
The password to use when connecting to the server as the superuser\&. If you omit the
\fIpassword\fR
value following the
\fB\-\-spassword\fR
or
\fB\-p\fR
option on the command line,
\fBmysqlaccess\fR
prompts for one\&.
.sp
Specifying a password on the command line should be considered insecure\&. See
Section\ \&5.3.2.2, \(lqEnd-User Guidelines for Password Security\(rq\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: superuser option
.\" superuser option: mysqlaccess
\fB\-\-superuser=\fR\fB\fIuser_name\fR\fR,
\fB\-U \fR\fB\fIuser_name\fR\fR
.sp
Specify the user name for connecting as the superuser\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: table option
.\" table option: mysqlaccess
\fB\-\-table\fR,
\fB\-t\fR
.sp
Generate reports in table format\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: user option
.\" user option: mysqlaccess
\fB\-\-user=\fR\fB\fIuser_name\fR\fR,
\fB\-u \fR\fB\fIuser_name\fR\fR
.sp
The user name to use in the access privileges\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
.\" mysqlaccess: version option
.\" version option: mysqlaccess
\fB\-\-version\fR,
\fB\-v\fR
.sp
Display version information and exit\&.
.RE
.PP
If your MariaDB distribution is installed in some non\-standard location, you must change the location where
\fBmysqlaccess\fR
expects to find the
\fBmysql\fR
client\&. Edit the
mysqlaccess
script at approximately line 18\&. Search for a line that looks like this:
.sp
.if n \{\
.RS 4
.\}
.nf
$MYSQL     = \'/usr/local/bin/mysql\';    # path to mysql executable
.fi
.if n \{\
.RE
.\}
.PP
Change the path to reflect the location where
\fBmysql\fR
actually is stored on your system\&. If you do not do this, a
Broken pipe
error will occur when you run
\fBmysqlaccess\fR\&.
.SH "COPYRIGHT"
.br
.PP
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2015 MariaDB Foundation
.PP
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.
.PP
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.
.PP
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-1335 USA or see http://www.gnu.org/licenses/.
.sp
.SH "SEE ALSO"
For more information, please refer to the MariaDB Knowledge Base, available online at https://mariadb.com/kb/
.SH AUTHOR
MariaDB Foundation (http://www.mariadb.org/).

${this.title}

Code Editor : mysqlaccess.1