mysqluserclone --version (return code: 0)
MySQL Utilities mysqluserclone version 1.6.1
License type: GPLv2
mysqluserclone --help (return code: 0)
MySQL Utilities mysqluserclone version 1.6.1
License type: GPLv2
Usage: mysqluserclone --source=user:pass@host:port:socket --destination=user:pass@host:port:socket joe@localhost sam:secret1@localhost
mysqluserclone - clone a MySQL user account to one or more new users
Options:
--version show program's version number and exit
--help display a help message and exit
--license display program's license and exit
--ssl-ca=SSL_CA The path to a file that contains a list of trusted SSL
CAs.
--ssl-cert=SSL_CERT The name of the SSL certificate file to use for
establishing a secure connection.
--ssl-key=SSL_KEY The name of the SSL key file to use for establishing a
secure connection.
--ssl=SSL Specifies if the server connection requires use of
SSL. If an encrypted connection cannot be established,
the connection attempt fails. By default 0 (SSL not
required).
--source=SOURCE connection information for source server in the form:
<user>[:<password>]@<host>[:<port>][:<socket>] or
<login-path>[:<port>][:<socket>] or <config-
path>[<[group]>].
--destination=DESTINATION
connection information for destination server in the
form: <user>[:<password>]@<host>[:<port>][:<socket>]
or <login-path>[:<port>][:<socket>] or <config-
path>[<[group]>].
-d, --dump dump GRANT statements for user - does not require a
destination
--force drop the new user if it exists
--include-global-privileges
include privileges that match base_user@% as well as
base_user@host
-l, --list list all users on the source - does not require a
destination
-f FORMAT, --format=FORMAT
display the list of users in either grid (default),
tab, csv, or vertical format - valid only for --list
option
-v, --verbose control how much information is displayed. e.g., -v =
verbose, -vv = more verbose, -vvv = debug
-q, --quiet turn off all messages for quiet execution.