习科小黑板 - Silic Wiki

CREATE USER 'silic'@'%' IDENTIFIED BY '123456';  
CREATE USER 'silic'@'%';
GRANT ALL ON *.* TO 'silic'@'%';
REVOKE ALL PRIVILEGES ON *.* FROM 'silic'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'silic'@'%'WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

SHOW FULL PROCESSLIST;

FLUSH PRIVILEGES;

select table_schema, sum((data_length+index_length)/1024/1024) M from information_schema.tables where table_schema is not null group by table_schema;

select @@secure-file-priv;