mirror of
https://github.com/MariaDB/server.git
synced 2025-09-16 16:42:28 +03:00
11 lines
397 B
Plaintext
11 lines
397 B
Plaintext
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';
|