← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/connect.test

  • 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/t/connect.test
19
19
show tables;
20
20
 
21
21
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
22
 
--error 1045
 
22
--error 1049
23
23
connect (fail_con,localhost,root,z,test2);
24
24
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
25
 
--error 1045
26
25
connect (fail_con,localhost,root,z,);
27
 
 
28
 
grant ALL on *.* to test@localhost identified by "gambling";
29
 
grant ALL on *.* to test@127.0.0.1 identified by "gambling";
 
26
--disconnect fail_con
30
27
 
31
28
# Now check this user with different databases
32
29
#connect (con1,localhost,test,gambling,"");
37
34
show tables;
38
35
 
39
36
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
40
 
--error 1045
 
37
--error 1049
41
38
connect (fail_con,localhost,test,,test2);
42
39
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
43
 
--error 1045
 
40
--error 1049
44
41
connect (fail_con,localhost,test,,"");
45
42
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
46
 
--error 1045
 
43
--error 1049
47
44
connect (fail_con,localhost,test,zorro,test2);
48
45
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
49
 
--error 1045
50
46
connect (fail_con,localhost,test,zorro,);
51
 
 
52
 
 
53
 
# check if old password version also works
54
 
update mysql.user set password=old_password("gambling2") where user=_binary"test";
55
 
flush privileges;
56
 
 
57
 
connect (con10,localhost,test,gambling2,);
58
 
connect (con5,localhost,test,gambling2,mysql);
59
 
connection con5;
60
 
set password="";
61
 
--error 1372
62
 
set password='gambling3';
63
 
set password=old_password('gambling3');
64
 
show tables;
65
 
connect (con6,localhost,test,gambling3,test);
66
 
show tables;
 
47
--disconnect fail_con
 
48
 
 
49
 
67
50
 
68
51
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
69
 
--error 1045
 
52
--error 1049
70
53
connect (fail_con,localhost,test,,test2);
71
54
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
72
 
--error 1045
73
55
connect (fail_con,localhost,test,,);
 
56
--disconnect fail_con
74
57
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
75
 
--error 1045
 
58
--error 1049
76
59
connect (fail_con,localhost,test,zorro,test2);
77
60
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
78
 
--error 1045
79
61
connect (fail_con,localhost,test,zorro,);
80
 
 
81
 
 
82
 
# remove user 'test' so that other tests which may use 'test'
83
 
# do not depend on this test.
84
 
 
85
 
delete from mysql.user where user=_binary"test";
86
 
flush privileges;
 
62
--disconnect fail_con
 
63
 
 
64
 
87
65
 
88
66
#
89
67
# Bug#12517: Clear user variables and replication events before 
103
81
--disconnect con2
104
82
--disconnect con3
105
83
--disconnect con4
106
 
--disconnect con5
107
 
--disconnect con6
108
 
--disconnect con10
109
84
 
110
85
--echo # ------------------------------------------------------------------
111
86
--echo # -- End of 4.1 tests