|
1
by brian
clean slate |
1 |
drop table if exists t1,t2; |
2 |
show tables; |
|
3 |
Tables_in_mysql
|
|
4 |
columns_priv
|
|
5 |
db
|
|
6 |
event
|
|
7 |
func
|
|
8 |
general_log
|
|
9 |
help_category
|
|
10 |
help_keyword
|
|
11 |
help_relation
|
|
12 |
help_topic
|
|
13 |
host
|
|
14 |
ndb_binlog_index
|
|
15 |
online_backup
|
|
16 |
online_backup_progress
|
|
17 |
plugin
|
|
18 |
proc
|
|
19 |
procs_priv
|
|
20 |
servers
|
|
21 |
slow_log
|
|
22 |
tables_priv
|
|
23 |
time_zone
|
|
24 |
time_zone_leap_second
|
|
25 |
time_zone_name
|
|
26 |
time_zone_transition
|
|
27 |
time_zone_transition_type
|
|
28 |
user
|
|
29 |
show tables; |
|
30 |
Tables_in_test
|
|
31 |
connect(localhost,root,z,test2,MASTER_PORT,MASTER_SOCKET); |
|
32 |
ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) |
|
33 |
connect(localhost,root,z,test,MASTER_PORT,MASTER_SOCKET); |
|
34 |
ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) |
|
35 |
grant ALL on *.* to test@localhost identified by "gambling"; |
|
36 |
grant ALL on *.* to test@127.0.0.1 identified by "gambling"; |
|
37 |
show tables; |
|
38 |
Tables_in_mysql
|
|
39 |
columns_priv
|
|
40 |
db
|
|
41 |
event
|
|
42 |
func
|
|
43 |
general_log
|
|
44 |
help_category
|
|
45 |
help_keyword
|
|
46 |
help_relation
|
|
47 |
help_topic
|
|
48 |
host
|
|
49 |
ndb_binlog_index
|
|
50 |
online_backup
|
|
51 |
online_backup_progress
|
|
52 |
plugin
|
|
53 |
proc
|
|
54 |
procs_priv
|
|
55 |
servers
|
|
56 |
slow_log
|
|
57 |
tables_priv
|
|
58 |
time_zone
|
|
59 |
time_zone_leap_second
|
|
60 |
time_zone_name
|
|
61 |
time_zone_transition
|
|
62 |
time_zone_transition_type
|
|
63 |
user
|
|
64 |
show tables; |
|
65 |
Tables_in_test
|
|
66 |
connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET); |
|
67 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) |
|
68 |
connect(localhost,test,,"",MASTER_PORT,MASTER_SOCKET); |
|
69 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) |
|
70 |
connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET); |
|
71 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) |
|
72 |
connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET); |
|
73 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) |
|
74 |
update mysql.user set password=old_password("gambling2") where user=_binary"test"; |
|
75 |
flush privileges; |
|
76 |
set password=""; |
|
77 |
set password='gambling3'; |
|
78 |
ERROR HY000: Password hash should be a 41-digit hexadecimal number |
|
79 |
set password=old_password('gambling3'); |
|
80 |
show tables; |
|
81 |
Tables_in_mysql
|
|
82 |
columns_priv
|
|
83 |
db
|
|
84 |
event
|
|
85 |
func
|
|
86 |
general_log
|
|
87 |
help_category
|
|
88 |
help_keyword
|
|
89 |
help_relation
|
|
90 |
help_topic
|
|
91 |
host
|
|
92 |
ndb_binlog_index
|
|
93 |
online_backup
|
|
94 |
online_backup_progress
|
|
95 |
plugin
|
|
96 |
proc
|
|
97 |
procs_priv
|
|
98 |
servers
|
|
99 |
slow_log
|
|
100 |
tables_priv
|
|
101 |
time_zone
|
|
102 |
time_zone_leap_second
|
|
103 |
time_zone_name
|
|
104 |
time_zone_transition
|
|
105 |
time_zone_transition_type
|
|
106 |
user
|
|
107 |
show tables; |
|
108 |
Tables_in_test
|
|
109 |
connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET); |
|
110 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) |
|
111 |
connect(localhost,test,,test,MASTER_PORT,MASTER_SOCKET); |
|
112 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO) |
|
113 |
connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET); |
|
114 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) |
|
115 |
connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET); |
|
116 |
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES) |
|
117 |
delete from mysql.user where user=_binary"test"; |
|
118 |
flush privileges; |
|
119 |
create table t1 (id integer not null auto_increment primary key); |
|
120 |
create temporary table t2(id integer not null auto_increment primary key); |
|
121 |
set @id := 1; |
|
122 |
delete from t1 where id like @id; |
|
123 |
drop table t1; |
|
124 |
# ------------------------------------------------------------------
|
|
125 |
# -- End of 4.1 tests
|
|
126 |
# ------------------------------------------------------------------
|
|
127 |
# ------------------------------------------------------------------
|
|
128 |
# -- End of 5.1 tests
|
|
129 |
# ------------------------------------------------------------------
|