sp-security.result 18.4 KB
Newer Older
1
use test;
2 3
grant usage on *.* to user1@localhost;
flush privileges;
4
drop table if exists t1;
5 6
drop database if exists db1_secret;
create database db1_secret;
7 8
create procedure db1_secret.dummy() begin end;
drop procedure db1_secret.dummy;
9 10
use db1_secret;
create table t1 ( u varchar(64), i int );
11
insert into t1 values('test', 0);
12 13 14
create procedure stamp(i int)
insert into db1_secret.t1 values (user(), i);
show procedure status like 'stamp';
15 16
Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation
db1_secret	stamp	PROCEDURE	root@localhost	0000-00-00 00:00:00	0000-00-00 00:00:00	DEFINER		latin1	latin1_swedish_ci	latin1_swedish_ci
17 18 19 20 21 22
create function db() returns varchar(64)
begin
declare v varchar(64);
select u into v from t1 limit 1;
return v;
end|
23
show function status like 'db';
24 25
Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation
db1_secret	db	FUNCTION	root@localhost	0000-00-00 00:00:00	0000-00-00 00:00:00	DEFINER		latin1	latin1_swedish_ci	latin1_swedish_ci
26 27 28
call stamp(1);
select * from t1;
u	i
29
test	0
30
root@localhost	1
31 32
select db();
db()
33
test
34 35 36 37
grant execute on procedure db1_secret.stamp to user1@'%';
grant execute on function db1_secret.db to user1@'%';
grant execute on procedure db1_secret.stamp to ''@'%';
grant execute on function db1_secret.db to ''@'%';
38
call db1_secret.stamp(2);
39 40
select db1_secret.db();
db1_secret.db()
41
test
42
select * from db1_secret.t1;
serg@sergbook.mysql.com's avatar
serg@sergbook.mysql.com committed
43
ERROR 42000: SELECT command denied to user 'user1'@'localhost' for table 't1'
44
create procedure db1_secret.dummy() begin end;
45
ERROR 42000: Access denied for user 'user1'@'localhost' to database 'db1_secret'
46 47
drop procedure db1_secret.dummy;
ERROR 42000: PROCEDURE db1_secret.dummy does not exist
48 49 50 51
drop procedure db1_secret.stamp;
ERROR 42000: alter routine command denied to user 'user1'@'localhost' for routine 'db1_secret.stamp'
drop function db1_secret.db;
ERROR 42000: alter routine command denied to user 'user1'@'localhost' for routine 'db1_secret.db'
52
call db1_secret.stamp(3);
53 54
select db1_secret.db();
db1_secret.db()
55
test
56
select * from db1_secret.t1;
serg@sergbook.mysql.com's avatar
serg@sergbook.mysql.com committed
57
ERROR 42000: SELECT command denied to user ''@'localhost' for table 't1'
58
create procedure db1_secret.dummy() begin end;
59
ERROR 42000: Access denied for user ''@'%' to database 'db1_secret'
60 61
drop procedure db1_secret.dummy;
ERROR 42000: PROCEDURE db1_secret.dummy does not exist
62 63 64 65
drop procedure db1_secret.stamp;
ERROR 42000: alter routine command denied to user ''@'%' for routine 'db1_secret.stamp'
drop function db1_secret.db;
ERROR 42000: alter routine command denied to user ''@'%' for routine 'db1_secret.db'
66 67
select * from t1;
u	i
68
test	0
69
root@localhost	1
70
user1@localhost	2
71 72 73
anon@localhost	3
alter procedure stamp sql security invoker;
show procedure status like 'stamp';
74 75
Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation
db1_secret	stamp	PROCEDURE	root@localhost	0000-00-00 00:00:00	0000-00-00 00:00:00	INVOKER		latin1	latin1_swedish_ci	latin1_swedish_ci
76 77
alter function db sql security invoker;
show function status like 'db';
78 79
Db	Name	Type	Definer	Modified	Created	Security_type	Comment	character_set_client	collation_connection	Database Collation
db1_secret	db	FUNCTION	root@localhost	0000-00-00 00:00:00	0000-00-00 00:00:00	INVOKER		latin1	latin1_swedish_ci	latin1_swedish_ci
80 81 82
call stamp(4);
select * from t1;
u	i
83
test	0
84
root@localhost	1
85
user1@localhost	2
86 87
anon@localhost	3
root@localhost	4
88 89
select db();
db()
90
test
91
call db1_secret.stamp(5);
92
ERROR 42000: INSERT command denied to user 'user1'@'localhost' for table 't1'
93
select db1_secret.db();
94
ERROR 42000: SELECT command denied to user 'user1'@'localhost' for table 't1'
95
call db1_secret.stamp(6);
96
ERROR 42000: INSERT command denied to user ''@'localhost' for table 't1'
97
select db1_secret.db();
98
ERROR 42000: SELECT command denied to user ''@'localhost' for table 't1'
99 100 101 102 103 104 105 106
drop database if exists db2;
create database db2;
use db2;
create table t2 (s1 int);
insert into t2 values (0);
grant usage on db2.* to user1@localhost;
grant select on db2.* to user1@localhost;
grant usage on db2.* to user2@localhost;
107 108
grant select,insert,update,delete,create routine on db2.* to user2@localhost;
grant create routine on db2.* to user1@localhost;
109 110 111 112
flush privileges;
use db2;
create procedure p () insert into t2 values (1);
call p();
serg@sergbook.mysql.com's avatar
serg@sergbook.mysql.com committed
113
ERROR 42000: INSERT command denied to user 'user1'@'localhost' for table 't2'
114 115
use db2;
call p();
116
ERROR 42000: execute command denied to user 'user2'@'localhost' for routine 'db2.p'
117 118 119 120 121 122 123 124 125
select * from t2;
s1
0
create procedure q () insert into t2 values (2);
call q();
select * from t2;
s1
0
2
126 127
grant usage on procedure db2.q to user2@localhost with grant option;
grant execute on procedure db2.q to user1@localhost;
128 129 130 131 132 133 134
use db2;
call q();
select * from t2;
s1
0
2
2
135 136 137
alter procedure p modifies sql data;
drop procedure p;
alter procedure q modifies sql data;
138
ERROR 42000: alter routine command denied to user 'user1'@'localhost' for routine 'db2.q'
139
drop procedure q;
140
ERROR 42000: alter routine command denied to user 'user1'@'localhost' for routine 'db2.q'
141 142 143
use db2;
alter procedure q modifies sql data;
drop procedure q;
144
use test;
145
select type,db,name from mysql.proc where db like 'db%';
146 147 148
type	db	name
FUNCTION	db1_secret	db
PROCEDURE	db1_secret	stamp
149
drop database db1_secret;
150
drop database db2;
151
select type,db,name from mysql.proc where db like 'db%';
152
type	db	name
153
delete from mysql.user where user='user1' or user='user2';
154
delete from mysql.user where user='' and host='%';
155
delete from mysql.procs_priv where user='user1' or user='user2';
156 157 158
delete from mysql.procs_priv where user='' and host='%';
delete from mysql.db where user='user2';
flush privileges;
159 160 161 162 163 164 165
grant usage on *.* to usera@localhost;
grant usage on *.* to userb@localhost;
grant usage on *.* to userc@localhost;
create database sptest;
create table t1 ( u varchar(64), i int );
create procedure sptest.p1(i int) insert into test.t1 values (user(), i);
grant insert on t1 to usera@localhost;
166
grant execute on procedure sptest.p1 to usera@localhost;
167 168 169 170
show grants for usera@localhost;
Grants for usera@localhost
GRANT USAGE ON *.* TO 'usera'@'localhost'
GRANT INSERT ON `test`.`t1` TO 'usera'@'localhost'
171 172
GRANT EXECUTE ON PROCEDURE `sptest`.`p1` TO 'usera'@'localhost'
grant execute on procedure sptest.p1 to userc@localhost with grant option;
173 174 175
show grants for userc@localhost;
Grants for userc@localhost
GRANT USAGE ON *.* TO 'userc'@'localhost'
176
GRANT EXECUTE ON PROCEDURE `sptest`.`p1` TO 'userc'@'localhost' WITH GRANT OPTION
177
call sptest.p1(1);
178
grant execute on procedure sptest.p1 to userb@localhost;
179 180
ERROR 42000: grant command denied to user 'usera'@'localhost' for routine 'sptest.p1'
drop procedure sptest.p1;
181
ERROR 42000: alter routine command denied to user 'usera'@'localhost' for routine 'sptest.p1'
182 183
call sptest.p1(2);
ERROR 42000: execute command denied to user 'userb'@'localhost' for routine 'sptest.p1'
184
grant execute on procedure sptest.p1 to userb@localhost;
185 186
ERROR 42000: execute command denied to user 'userb'@'localhost' for routine 'sptest.p1'
drop procedure sptest.p1;
187
ERROR 42000: alter routine command denied to user 'userb'@'localhost' for routine 'sptest.p1'
188
call sptest.p1(3);
189
grant execute on procedure sptest.p1 to userb@localhost;
190
drop procedure sptest.p1;
191
ERROR 42000: alter routine command denied to user 'userc'@'localhost' for routine 'sptest.p1'
192
call sptest.p1(4);
193
grant execute on procedure sptest.p1 to userb@localhost;
194 195
ERROR 42000: grant command denied to user 'userb'@'localhost' for routine 'sptest.p1'
drop procedure sptest.p1;
196
ERROR 42000: alter routine command denied to user 'userb'@'localhost' for routine 'sptest.p1'
197 198 199 200 201
select * from t1;
u	i
usera@localhost	1
userc@localhost	3
userb@localhost	4
202
grant all privileges on procedure sptest.p1 to userc@localhost;
203 204 205
show grants for userc@localhost;
Grants for userc@localhost
GRANT USAGE ON *.* TO 'userc'@'localhost'
206
GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE `sptest`.`p1` TO 'userc'@'localhost' WITH GRANT OPTION
207 208 209
show grants for userb@localhost;
Grants for userb@localhost
GRANT USAGE ON *.* TO 'userb'@'localhost'
210 211
GRANT EXECUTE ON PROCEDURE `sptest`.`p1` TO 'userb'@'localhost'
revoke all privileges on procedure sptest.p1 from userb@localhost;
212 213 214 215 216 217 218
show grants for userb@localhost;
Grants for userb@localhost
GRANT USAGE ON *.* TO 'userb'@'localhost'
use test;
drop database sptest;
delete from mysql.user where user='usera' or user='userb' or user='userc';
delete from mysql.procs_priv where user='usera' or user='userb' or user='userc';
219 220 221
delete from mysql.tables_priv where user='usera';
flush privileges;
drop table t1;
222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238
drop function if exists bug_9503;
create database mysqltest//
use mysqltest//
create table t1 (s1 int)//
grant select on t1 to user1@localhost//
create function bug_9503 () returns int sql security invoker begin declare v int;
select min(s1) into v from t1; return v; end//
use mysqltest;
select bug_9503();
ERROR 42000: execute command denied to user 'user1'@'localhost' for routine 'mysqltest.bug_9503'
grant execute on function bug_9503 to user1@localhost;
do 1;
use test;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
drop function bug_9503;
use test;
drop database mysqltest;
239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262
use test;
select current_user();
current_user()
root@localhost
select user();
user()
root@localhost
create procedure bug7291_0 () sql security invoker select current_user(), user();
create procedure bug7291_1 () sql security definer call bug7291_0();
create procedure bug7291_2 () sql security invoker call bug7291_0();
grant execute on procedure bug7291_0 to user1@localhost;
grant execute on procedure bug7291_1 to user1@localhost;
grant execute on procedure bug7291_2 to user1@localhost;
call bug7291_2();
current_user()	user()
user1@localhost	user1@localhost
call bug7291_1();
current_user()	user()
root@localhost	user1@localhost
drop procedure bug7291_1;
drop procedure bug7291_2;
drop procedure bug7291_0;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
drop user user1@localhost;
263 264 265 266 267 268 269 270 271
drop database if exists mysqltest_1;
create database mysqltest_1;
create procedure mysqltest_1.p1()
begin
select 1 from dual;
end//
grant usage on *.* to mysqltest_1@localhost;
call mysqltest_1.p1();
ERROR 42000: execute command denied to user 'mysqltest_1'@'localhost' for routine 'mysqltest_1.p1'
272 273
call mysqltest_1.p1();
ERROR 42000: execute command denied to user 'mysqltest_1'@'localhost' for routine 'mysqltest_1.p1'
274 275 276 277
drop procedure mysqltest_1.p1;
drop database mysqltest_1;
revoke usage on *.* from mysqltest_1@localhost;
drop user mysqltest_1@localhost;
278 279 280 281 282 283 284 285 286 287 288 289
drop function if exists bug12812|
create function bug12812() returns char(2)
begin
return 'ok';
end;
create user user_bug12812@localhost IDENTIFIED BY 'ABC'|
SELECT test.bug12812()|
ERROR 42000: execute command denied to user 'user_bug12812'@'localhost' for routine 'test.bug12812'
CREATE VIEW v1 AS SELECT test.bug12812()|
ERROR 42000: execute command denied to user 'user_bug12812'@'localhost' for routine 'test.bug12812'
DROP USER user_bug12812@localhost|
drop function bug12812|
290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310
create database db_bug14834;
create user user1_bug14834@localhost identified by '';
grant all on `db\_bug14834`.* to user1_bug14834@localhost;
create user user2_bug14834@localhost identified by '';
grant all on `db\_bug14834`.* to user2_bug14834@localhost;
create user user3_bug14834@localhost identified by '';
grant all on `db__ug14834`.* to user3_bug14834@localhost;
create procedure p_bug14834() select user(), current_user();
call p_bug14834();
user()	current_user()
user1_bug14834@localhost	user1_bug14834@localhost
call p_bug14834();
user()	current_user()
user2_bug14834@localhost	user1_bug14834@localhost
call p_bug14834();
user()	current_user()
user3_bug14834@localhost	user1_bug14834@localhost
drop user user1_bug14834@localhost;
drop user user2_bug14834@localhost;
drop user user3_bug14834@localhost;
drop database db_bug14834;
311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333
create database db_bug14533;
use db_bug14533;
create table t1 (id int);
create user user_bug14533@localhost identified by '';
create procedure bug14533_1()
sql security definer
desc db_bug14533.t1;
create procedure bug14533_2()
sql security definer
select * from db_bug14533.t1;
grant execute on procedure db_bug14533.bug14533_1 to user_bug14533@localhost;
grant execute on procedure db_bug14533.bug14533_2 to user_bug14533@localhost;
call db_bug14533.bug14533_1();
Field	Type	Null	Key	Default	Extra
id	int(11)	YES		NULL	
call db_bug14533.bug14533_2();
id
desc db_bug14533.t1;
ERROR 42000: SELECT command denied to user 'user_bug14533'@'localhost' for table 't1'
select * from db_bug14533.t1;
ERROR 42000: SELECT command denied to user 'user_bug14533'@'localhost' for table 't1'
drop user user_bug14533@localhost;
drop database db_bug14533;
334 335 336 337 338 339 340 341 342 343 344

---> connection: root
DROP DATABASE IF EXISTS mysqltest;
CREATE DATABASE mysqltest;
CREATE USER mysqltest_1@localhost;
GRANT ALL PRIVILEGES ON mysqltest.* TO mysqltest_1@localhost;
CREATE USER mysqltest_2@localhost;
GRANT SUPER ON *.* TO mysqltest_2@localhost;
GRANT ALL PRIVILEGES ON mysqltest.* TO mysqltest_2@localhost;

---> connection: mysqltest_2_con
345
USE mysqltest;
346 347 348 349
CREATE PROCEDURE wl2897_p1() SELECT 1;
CREATE FUNCTION wl2897_f1() RETURNS INT RETURN 1;

---> connection: mysqltest_1_con
350
USE mysqltest;
351 352 353 354 355 356 357 358 359
CREATE DEFINER=root@localhost PROCEDURE wl2897_p2() SELECT 2;
ERROR 42000: Access denied; you need the SUPER privilege for this operation
CREATE DEFINER=root@localhost FUNCTION wl2897_f2() RETURNS INT RETURN 2;
ERROR 42000: Access denied; you need the SUPER privilege for this operation

---> connection: mysqltest_2_con
use mysqltest;
CREATE DEFINER='a @ b @ c'@localhost PROCEDURE wl2897_p3() SELECT 3;
Warnings:
360
Note	1449	The user specified as a definer ('a @ b @ c'@'localhost') does not exist
361 362
CREATE DEFINER='a @ b @ c'@localhost FUNCTION wl2897_f3() RETURNS INT RETURN 3;
Warnings:
363
Note	1449	The user specified as a definer ('a @ b @ c'@'localhost') does not exist
364 365

---> connection: con1root
366
USE mysqltest;
367
SHOW CREATE PROCEDURE wl2897_p1;
368
Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation
369
wl2897_p1		CREATE DEFINER=`mysqltest_2`@`localhost` PROCEDURE `wl2897_p1`()
370
SELECT 1	latin1	latin1_swedish_ci	latin1_swedish_ci
371
SHOW CREATE PROCEDURE wl2897_p3;
372
Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation
373
wl2897_p3		CREATE DEFINER=`a @ b @ c`@`localhost` PROCEDURE `wl2897_p3`()
374
SELECT 3	latin1	latin1_swedish_ci	latin1_swedish_ci
375
SHOW CREATE FUNCTION wl2897_f1;
376
Function	sql_mode	Create Function	character_set_client	collation_connection	Database Collation
377
wl2897_f1		CREATE DEFINER=`mysqltest_2`@`localhost` FUNCTION `wl2897_f1`() RETURNS int(11)
378
RETURN 1	latin1	latin1_swedish_ci	latin1_swedish_ci
379
SHOW CREATE FUNCTION wl2897_f3;
380
Function	sql_mode	Create Function	character_set_client	collation_connection	Database Collation
381
wl2897_f3		CREATE DEFINER=`a @ b @ c`@`localhost` FUNCTION `wl2897_f3`() RETURNS int(11)
382
RETURN 3	latin1	latin1_swedish_ci	latin1_swedish_ci
383 384 385
DROP USER mysqltest_1@localhost;
DROP USER mysqltest_2@localhost;
DROP DATABASE mysqltest;
386 387 388 389 390 391 392 393 394 395

---> connection: root
DROP DATABASE IF EXISTS mysqltest;
CREATE DATABASE mysqltest;
CREATE USER mysqltest_1@localhost;
GRANT ALL PRIVILEGES ON mysqltest.* TO mysqltest_1@localhost;
CREATE USER mysqltest_2@localhost;
GRANT ALL PRIVILEGES ON mysqltest.* TO mysqltest_2@localhost;

---> connection: mysqltest_1_con
396
USE mysqltest;
397 398 399 400 401 402 403 404 405 406 407 408
CREATE PROCEDURE bug13198_p1()
SELECT 1;
CREATE FUNCTION bug13198_f1() RETURNS INT
RETURN 1;
CALL bug13198_p1();
1
1
SELECT bug13198_f1();
bug13198_f1()
1

---> connection: mysqltest_2_con
409
USE mysqltest;
410 411 412 413 414 415 416 417 418 419 420
CALL bug13198_p1();
1
1
SELECT bug13198_f1();
bug13198_f1()
1

---> connection: root
DROP USER mysqltest_1@localhost;

---> connection: mysqltest_2_con
421
USE mysqltest;
422
CALL bug13198_p1();
423
ERROR HY000: The user specified as a definer ('mysqltest_1'@'localhost') does not exist
424
SELECT bug13198_f1();
425
ERROR HY000: The user specified as a definer ('mysqltest_1'@'localhost') does not exist
426 427 428 429

---> connection: root
DROP USER mysqltest_2@localhost;
DROP DATABASE mysqltest;
430 431 432 433 434 435 436 437
GRANT USAGE ON *.* TO user19857@localhost IDENTIFIED BY 'meow';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ROUTINE, ALTER ROUTINE ON test.* TO
user19857@localhost;
SELECT Host,User,Password FROM mysql.user WHERE User='user19857';
Host	User	Password
localhost	user19857	*82DC221D557298F6CE9961037DB1C90604792F5C

---> connection: mysqltest_2_con
438
USE test;
439 440 441 442 443 444 445
CREATE PROCEDURE sp19857() DETERMINISTIC
BEGIN
DECLARE a INT;
SET a=1;
SELECT a;
END //
SHOW CREATE PROCEDURE test.sp19857;
446
Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation
447 448 449 450 451 452
sp19857		CREATE DEFINER=`user19857`@`localhost` PROCEDURE `sp19857`()
    DETERMINISTIC
BEGIN
DECLARE a INT;
SET a=1;
SELECT a;
453
END	latin1	latin1_swedish_ci	latin1_swedish_ci
454 455 456 457 458 459 460
DROP PROCEDURE IF EXISTS test.sp19857;

---> connection: root
SELECT Host,User,Password FROM mysql.user WHERE User='user19857';
Host	User	Password
localhost	user19857	*82DC221D557298F6CE9961037DB1C90604792F5C
DROP USER user19857@localhost;
461
use test;
462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513
DROP TABLE IF EXISTS t1;
DROP VIEW IF EXISTS v1;
DROP FUNCTION IF EXISTS f_suid;
DROP PROCEDURE IF EXISTS p_suid;
DROP FUNCTION IF EXISTS f_evil;
DELETE FROM mysql.user WHERE user LIKE 'mysqltest\_%';
DELETE FROM mysql.db WHERE user LIKE 'mysqltest\_%';
DELETE FROM mysql.tables_priv WHERE user LIKE 'mysqltest\_%';
DELETE FROM mysql.columns_priv WHERE user LIKE 'mysqltest\_%';
FLUSH PRIVILEGES;
CREATE TABLE t1 (i INT);
CREATE FUNCTION f_suid(i INT) RETURNS INT SQL SECURITY DEFINER RETURN 0;
CREATE PROCEDURE p_suid(IN i INT) SQL SECURITY DEFINER SET @c:= 0;
CREATE USER mysqltest_u1@localhost;
GRANT EXECUTE ON test.* TO mysqltest_u1@localhost;
CREATE DEFINER=mysqltest_u1@localhost FUNCTION f_evil () RETURNS INT
SQL SECURITY INVOKER
BEGIN
SET @a:= CURRENT_USER();
SET @b:= (SELECT COUNT(*) FROM t1);
RETURN @b;
END|
CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT f_evil();
SELECT COUNT(*) FROM t1;
ERROR 42000: SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't1'
SELECT f_evil();
ERROR 42000: SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't1'
SELECT @a, @b;
@a	@b
mysqltest_u1@localhost	NULL
SELECT f_suid(f_evil());
ERROR 42000: SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't1'
SELECT @a, @b;
@a	@b
mysqltest_u1@localhost	NULL
CALL p_suid(f_evil());
ERROR 42000: SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't1'
SELECT @a, @b;
@a	@b
mysqltest_u1@localhost	NULL
SELECT * FROM v1;
ERROR 42000: SELECT command denied to user 'mysqltest_u1'@'localhost' for table 'v1'
SELECT @a, @b;
@a	@b
mysqltest_u1@localhost	NULL
DROP VIEW v1;
DROP FUNCTION f_evil;
DROP USER mysqltest_u1@localhost;
DROP PROCEDURE p_suid;
DROP FUNCTION f_suid;
DROP TABLE t1;
End of 5.0 tests.