mysqluserclone 以现有数据库上的用户作为模板创作一个或多个具有相同权限的账户。新的账号可以创建在原始服务器或一个不同的服务器上。
如果想列出所有用户，指定–list 选项。
输出格式
- grid (default)
- csv
- tab
- vertical
选项
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
MySQL Utilities mysqluserclone version 1.5.3
License type: GPLv2
Usage: mysqluserclone —source=user:pass@host:port:socket —destination=user:pass@host:port:socket joe@trustauth.cn sam:secret1@trustauth.cn
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.
—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。显示GRANT语句而不是执行。
—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.
|
实例
列出所有用户
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# mysqluserclone –source=instance_3306 –list -vvv –format=v
# Source on trustauth.cn: … connected.
# All Users:
************************* 1. row *************************
user: root
host: 127.0.0.1
database: None
************************* 2. row *************************
user: root
host: ::1
database: None
************************* 3. row *************************
user: admin
host: trustauth.cn
database: None
************************* 4. row *************************
user: root
host: trustauth.cn
database: None
************************* 5. row *************************
user: root
host: trustauth.cn.localdomain
database: None
5 rows.
|
复制admin用户到3308实例，用户名为user1，密码为passwd1，主机为10.%
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
# mysqluserclone –source=instance_3306 –destination=instance_3308 admin@trustauth.cn user1:passwd1@10.% -vvv
WARNING: Using a password on the command line interface can be insecure.
# Source on trustauth.cn: … connected.
# Destination on trustauth.cn: … connected.
# Cloning 1 users…
# Cloning admin@trustauth.cn to user user1:passwd1@10.%
CREATE USER ‘user1’@’10.%’ IDENTIFIED BY ‘passwd1’
GRANT SHUTDOWN ON *.* TO ‘user1’@’10.%’
# …done.
# mysqluserclone –source=instance_3308 –list -vvv –format=v
# Source on trustauth.cn: … connected.
# All Users:
************************* 1. row *************************
user: user1
host: 10.%
database: None
************************* 2. row *************************
user: root
host: 127.0.0.1
database: None
************************* 3. row *************************
user: root
host: ::1
database: None
************************* 4. row *************************
user: admin
host: trustauth.cn
database: None
************************* 5. row *************************
user: root
host: trustauth.cn
database: None
************************* 6. row *************************
user: root
host: trustauth.cn.localdomain
database: None
6 rows.
|
权限
需要对mysql数据库SELECT权限和访问数据目录的权限。
文章转载来自：trustauth.cn
领取优惠
提交成功！