← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/connect.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/connect.result
 
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
# ------------------------------------------------------------------