添加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;
列出所有进程
权限刷新
统计数据库用量
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;