blob: 9523bdc22fd05ad26cf649269ef012376a057727 (
plain)
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
show tables;
Tables_in_mysql Type
columns_priv table
db table
func table
help_category table
help_keyword table
help_relation table
help_topic table
host table
proc table
tables_priv table
time_zone table
time_zone_leap_second table
time_zone_name table
time_zone_transition table
time_zone_transition_type table
user table
show tables;
Tables_in_test Type
grant ALL on *.* to test@localhost identified by "gambling";
grant ALL on *.* to test@127.0.0.1 identified by "gambling";
show tables;
Tables_in_mysql Type
columns_priv table
db table
func table
help_category table
help_keyword table
help_relation table
help_topic table
host table
proc table
tables_priv table
time_zone table
time_zone_leap_second table
time_zone_name table
time_zone_transition table
time_zone_transition_type table
user table
show tables;
Tables_in_test Type
update mysql.user set password=old_password("gambling2") where user=_binary"test";
flush privileges;
set password=old_password('gambling3');
show tables;
Tables_in_mysql Type
columns_priv table
db table
func table
help_category table
help_keyword table
help_relation table
help_topic table
host table
proc table
tables_priv table
time_zone table
time_zone_leap_second table
time_zone_name table
time_zone_transition table
time_zone_transition_type table
user table
show tables;
Tables_in_test Type
delete from mysql.user where user=_binary"test";
flush privileges;
|
