9
9
# of the log tables (which are CSV-based). By connect mysql; show tables;
10
10
--source include/have_csv.inc
12
# Save the initial number of concurrent sessions
13
--source include/count_sessions.inc
13
17
drop table if exists t1,t2;
17
20
#connect (con1,localhost,root,,"");
19
22
connect (con1,localhost,root,,mysql);
24
27
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
28
--error ER_ACCESS_DENIED_ERROR
26
29
connect (fail_con,localhost,root,z,test2);
27
30
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
31
--error ER_ACCESS_DENIED_ERROR
29
32
connect (fail_con,localhost,root,z,);
31
38
grant ALL on *.* to test@localhost identified by "gambling";
32
39
grant ALL on *.* to test@127.0.0.1 identified by "gambling";
39
46
connect (con4,localhost,test,gambling,test);
42
53
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
54
--error ER_ACCESS_DENIED_ERROR
44
55
connect (fail_con,localhost,test,,test2);
45
56
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
57
--error ER_ACCESS_DENIED_ERROR
47
58
connect (fail_con,localhost,test,,"");
48
59
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
60
--error ER_ACCESS_DENIED_ERROR
50
61
connect (fail_con,localhost,test,zorro,test2);
51
62
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
63
--error ER_ACCESS_DENIED_ERROR
53
64
connect (fail_con,localhost,test,zorro,);
56
66
# check if old password version also works
57
67
update mysql.user set password=old_password("gambling2") where user=_binary"test";
61
71
connect (con5,localhost,test,gambling2,mysql);
74
--error ER_PASSWD_LENGTH
65
75
set password='gambling3';
66
76
set password=old_password('gambling3');
68
78
connect (con6,localhost,test,gambling3,test);
71
86
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
87
--error ER_ACCESS_DENIED_ERROR
73
88
connect (fail_con,localhost,test,,test2);
74
89
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
90
--error ER_ACCESS_DENIED_ERROR
76
91
connect (fail_con,localhost,test,,);
77
92
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
93
--error ER_ACCESS_DENIED_ERROR
79
94
connect (fail_con,localhost,test,zorro,test2);
80
95
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
96
--error ER_ACCESS_DENIED_ERROR
82
97
connect (fail_con,localhost,test,zorro,);
85
100
# remove user 'test' so that other tests which may use 'test'
86
101
# do not depend on this test.
88
102
delete from mysql.user where user=_binary"test";
92
# Bug#12517: Clear user variables and replication events before
93
# closing temp tables in thread cleanup.
106
# Bug#12517 Clear user variables and replication events before
107
# closing temp tables in thread cleanup.
94
108
connect (con7,localhost,root,,test);
110
let $connection_id= `select connection_id()`;
96
111
create table t1 (id integer not null auto_increment primary key);
97
112
create temporary table t2(id integer not null auto_increment primary key);
99
114
delete from t1 where id like @id;
117
# Wait till the session con7 is disconnected
118
let $wait_condition =
120
FROM information_schema.processlist
121
WHERE id = '$connection_id';
122
--source include/wait_condition.inc
113
125
--echo # ------------------------------------------------------------------
114
126
--echo # -- End of 4.1 tests
115
127
--echo # ------------------------------------------------------------------
250
262
SET GLOBAL event_scheduler = ON;
252
264
--echo # -- Waiting for Event Scheduler to start...
253
let $wait_condition =
255
FROM information_schema.processlist
256
WHERE user = 'event_scheduler';
257
--source include/wait_condition.inc
265
--source include/running_event_scheduler.inc
259
267
# NOTE: We should use a new connection here instead of reconnect in order to
260
268
# avoid races (we can not for sure when the connection being disconnected is
278
286
SET GLOBAL event_scheduler = OFF;
280
288
--echo # -- Waiting for Event Scheduler to stop...
281
let $wait_condition =
283
FROM information_schema.processlist
284
WHERE user = 'event_scheduler';
285
--source include/wait_condition.inc
289
--source include/no_running_events.inc
288
292
--echo # -- End of Bug#35074.