summaryrefslogtreecommitdiff
path: root/mysql-test/r/connect.result
blob: 49ca53e82c3297340cd20a331ac3a7d8302c881b (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
show tables;
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
proc
tables_priv
user
show tables;
Tables_in_test
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
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
proc
tables_priv
user
show tables;
Tables_in_test
update mysql.user set password=old_password("gambling2") where user="test";
flush privileges;
show tables;
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
proc
tables_priv
user
show tables;
Tables_in_test
delete from mysql.user where user="test";
flush privileges;