1
set global log_warnings=0;
2
drop table if exists t1,t2;
27
time_zone_transition_type
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";
61
time_zone_transition_type
65
connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET);
66
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
67
connect(localhost,test,,"",MASTER_PORT,MASTER_SOCKET);
68
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
69
connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET);
70
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
71
connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET);
72
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
73
update mysql.user set password=old_password("gambling2") where user=_binary"test";
76
set password='gambling3';
77
ERROR HY000: Password hash should be a 41-digit hexadecimal number
78
set password=old_password('gambling3');
100
time_zone_leap_second
103
time_zone_transition_type
107
connect(localhost,test,,test2,MASTER_PORT,MASTER_SOCKET);
108
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
109
connect(localhost,test,,test,MASTER_PORT,MASTER_SOCKET);
110
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
111
connect(localhost,test,zorro,test2,MASTER_PORT,MASTER_SOCKET);
112
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
113
connect(localhost,test,zorro,test,MASTER_PORT,MASTER_SOCKET);
114
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
115
delete from mysql.user where user=_binary"test";
117
create table t1 (id integer not null auto_increment primary key);
118
create temporary table t2(id integer not null auto_increment primary key);
120
delete from t1 where id like @id;
122
# ------------------------------------------------------------------
123
# -- End of 4.1 tests
124
# ------------------------------------------------------------------
126
# -- Bug#33507: Event scheduler creates more threads than max_connections
127
# -- which results in user lockout.
129
GRANT USAGE ON *.* TO mysqltest_u1@localhost;
131
SET GLOBAL max_connections = 3;
132
SET GLOBAL event_scheduler = ON;
134
# -- Waiting for Event Scheduler to start...
136
# -- Disconnecting default connection...
138
# -- Check that we allow exactly three user connections, no matter how
139
# -- many threads are running.
141
# -- Connecting (1)...
142
# -- Establishing connection 'con_1' (user: mysqltest_u1)...
143
# -- Connection 'con_1' has been established.
145
# -- Connecting (2)...
146
# -- Establishing connection 'con_2' (user: mysqltest_u1)...
147
# -- Connection 'con_2' has been established.
149
# -- Connecting (3)...
150
# -- Establishing connection 'con_3' (user: mysqltest_u1)...
151
# -- Connection 'con_3' has been established.
153
# -- Connecting (4) [should fail]...
154
# -- Establishing connection 'con_4' (user: mysqltest_u1)...
155
# -- Error: can not establish connection 'con_4'.
157
# -- Check that we allow one extra SUPER-user connection.
159
# -- Connecting super (1)...
160
# -- Establishing connection 'con_super_1' (user: root)...
161
# -- Connection 'con_super_1' has been established.
163
# -- Connecting super (2) [should fail]...
164
# -- Establishing connection 'con_super_2' (user: root)...
165
# -- Error: can not establish connection 'con_super_2'.
167
# -- Ensure that we have Event Scheduler thread, 3 ordinary user
168
# -- connections and one extra super-user connection.
169
SELECT user FROM information_schema.processlist ORDER BY id;
177
# -- Resetting variables...
178
SET GLOBAL max_connections = 151;
180
# -- Stopping Event Scheduler...
181
SET GLOBAL event_scheduler = OFF;
183
# -- Waiting for Event Scheduler to stop...
185
# -- That's it. Closing connections...
187
# -- Restoring default connection...
189
# -- Waiting for connections to close...
191
DROP USER mysqltest_u1@localhost;
193
# -- End of Bug#33507.
195
# -- Bug#35074: max_used_connections is not correct.
199
SHOW STATUS LIKE 'max_used_connections';
201
Max_used_connections 1
203
# -- Starting Event Scheduler...
204
SET GLOBAL event_scheduler = ON;
205
# -- Waiting for Event Scheduler to start...
207
# -- Opening a new connection to check max_used_connections...
209
# -- Check that max_used_connections hasn't changed.
210
SHOW STATUS LIKE 'max_used_connections';
212
Max_used_connections 2
214
# -- Closing new connection...
216
# -- Stopping Event Scheduler...
217
SET GLOBAL event_scheduler = OFF;
218
# -- Waiting for Event Scheduler to stop...
220
# -- End of Bug#35074.
222
# ------------------------------------------------------------------
223
# -- End of 5.1 tests
224
# ------------------------------------------------------------------
225
set global log_warnings=1;