← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/connect.result

  • Committer: Monty Taylor
  • Date: 2008-12-24 01:49:53 UTC
  • mto: This revision was merged to the branch mainline in revision 751.
  • Revision ID: mordred@inaugust.com-20081224014953-rc9p7a162p74y889
Fixed connect.test.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/connect.result
1
1
drop table if exists t1,t2;
2
2
show tables;
3
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;
 
4
show tables;
 
5
Tables_in_test
 
6
connect(localhost,root,z,test2,MASTER_PORT,);
 
7
ERROR 42000: Unknown database 'test2'
 
8
show tables;
 
9
Tables_in_mysql
 
10
show tables;
 
11
Tables_in_test
 
12
connect(localhost,test,,test2,MASTER_PORT,);
 
13
ERROR 42000: Unknown database 'test2'
 
14
connect(localhost,test,,"",MASTER_PORT,);
 
15
ERROR 42000: Unknown database '""'
 
16
connect(localhost,test,zorro,test2,MASTER_PORT,);
 
17
ERROR 42000: Unknown database 'test2'
 
18
connect(localhost,test,,test2,MASTER_PORT,);
 
19
ERROR 42000: Unknown database 'test2'
 
20
connect(localhost,test,zorro,test2,MASTER_PORT,);
 
21
ERROR 42000: Unknown database 'test2'
119
22
create table t1 (id integer not null auto_increment primary key);
120
23
create temporary table t2(id integer not null auto_increment primary key);
121
24
set @id := 1;