添加root账户

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;

MySQL 5.7 允许读写的目录配置(NULL为无限制)

select @@secure-file-priv;