为管理员账号添加密码，默认任何主机可无密码登录这2个账号

SET PASSWORD FOR 'root'@'%' = PASSWORD('xxxxxxxxxxxx');

SET PASSWORD FOR 'admin'@'%' = PASSWORD('xxxxxxxxxxxx');

查看FE节点状态

SHOW PROC '/frontends'

查看BE节点状态

SHOW proc '/backends'

查看broker节点状态

SHOW proc '/brokers'

查看有哪些表

SHOW TABLES

查看表的数据大小

SHOW DATA

查看表的字段、索引情况

DESC table_name ALL

查看表的分区情况

SHOW PARTITIONS FROM table_name

查看表的tablet情况

SHOW tablet FROM table_name

查看当前执行sql的进程

SHOW PROCESSLIST

建用户授权、查看权限

CREATE USER 'dorisro'@'%' IDENTIFIED BY 'dorisro'

GRANT SELECT_PRIV ON *.* TO 'dorisro'@'%'

SHOW GRANTS FOR 'dorisro'

查看数据库用户属性

SHOW property FOR 'dorisro'

SET property FOR 'dorisro' 'max_user_connections' = '2000'

查看系统变量

SHOW VARIABLES LIKE '%bitmap%'

SET GLOBAL wait_timeout = 300

设置集群配置项

admin SET frontend config ("max_bytes_per_broker_scanner" = "85899345920");

admin SHOW frontend config LIKE '%broker%'

如果集群重启，会恢复到配置文件里的配置，所以如果要永久生效，需要修改配置文件。

查看load任务状态

SHOW LOAD WHERE label LIKE 'xxxxxxx';

查阅命令帮助

help 'show'