blob: 505861e89df08d4ab4eaaac5675a7adeb074485a (
plain)
1
2
3
4
5
6
7
8
9
10
|
select priv into @root_priv from mysql.global_priv where user='root' and host='localhost';
create role r1;
prepare stmt from "set password = '11111111111111111111111111111111111111111'";
execute stmt;
prepare stmt from "set default role r1";
execute stmt;
set password = '';
set default role NONE;
drop role r1;
update mysql.global_priv set priv=@root_priv where user='root' and host='localhost';
|
