[TOC] # 常用设置 ## 允许外网访问 设置 ``` //修改mysql.user表内的连接host //刷新权限 FLUSH PRIVILEGES ``` # 常用查询 ## 时间 ``` select id,name,FROM_UNIXTIME(time,'%Y-%m-%d %H:%i:%s') as addtime from testtable ``` # 优化 ## 查询各个表数据量 ``` select table_schema as '数据库', table_name as '表名', table_rows as '记录数', truncate(data_length/1024/1024, 2) as '数据容量(MB)', truncate(index_length/1024/1024, 2) as '索引容量(MB)' from information_schema.tables where table_schema='pintuan2-online-debug表名' order by table_rows desc, index_length desc; ```