mysql常用命令

 

use sAmple;

drop user mimi@localhost;

drop function if exists f_suid; 

drop database if exists sAmple; 

drop database if exists mysqltest1; 

drop database if exists mysqltest2; 

 

create database sAmple;

use sAmple;

create user mimi@localhost; 

create database mysqltest1; 

create database mysqltest2; 

use sAmple;

grant all privileges on mysqltest1.* to mimi@localhost; 

 

 

use mysqltest1; 

create function f_suid(i int) returns int return 0; 

grant execute on function mysqltest1.f_suid to mimi@localhost; 

 

use mysqltest2; 

 

create table t1 (i int); 

 

 

select * from mysqltest2.t1; 

 

 

delimiter // 

create function f_evil () 

returns int 

sql security invoker 

begin 

set @a:= current_user(); 

set @b:= (select count(*) from mysqltest2.t1); 

return 0; 

end;

//

select f_evil(); 

select @a, @b; 

 

select mysqltest1.f_suid(f_evil()); 

select @a, @b; 

 

drop user mimi@localhost; 

drop database mysqltest1; 

drop database mysqltest2; 

//