TDengine 小白第一章

• 卸载

【TDengine】解决 failed to connect to server, reason: Mnode not found
卸载命令(tar包解压方式安装的)：
$ rmtaos

卸载后删除配置文件
rm -rf /var/log/taos 
rm -rf /etc/taos
rm -rf /var/lib/taos/

• linux安装

• 请将 <version> 替换为下载的安装包版本

tar -zxvf TDengine-server-<version>-Linux-x64.tar.gz

• 解压文件后，进入相应子目录，执行其中的 install.sh 安装脚本：

sudo ./install.sh

#systemctl 命令可以帮助你管理 TDengine 服务：

 - 启动服务进程：systemctl start taosd

 - 停止服务进程：systemctl stop taosd

 - 重启服务进程：systemctl restart taosd

 - 查看服务状态：systemctl status taosd

• 创建修改 人员

# 查看所有用户
SHOW USERS;

taos> SHOW USERS;
           name           | super | enable | sysinfo |       create_time       |
================================================================================
 root                     |     1 |      1 |       1 | 2022-09-07 11:09:05.717 |
Query OK, 1 rows in database (0.002492s)

# 创建用户
taos> create user hss pass 'root';
Create OK, 0 row(s) affected (0.001345s)

# 修改用户
taos> ALTER USER hss PASS '456789';
Query OK, 0 of 0 rows affected (0.000591s)

taos> ALTER USER hss ENABLE 0;
Query OK, 0 of 0 rows affected (0.003619s)

taos> ALTER USER hss SYSINFO 0;
Query OK, 0 of 0 rows affected (0.003626s)

taos> SHOW USERS;
           name           | super | enable | sysinfo |       create_time       |
================================================================================
 hss 					  |     0 |      0 |       0 | 2022-09-08 15:45:43.188 |
 root                     |     1 |      1 |       1 | 2022-09-07 11:09:05.717 |
Query OK, 2 rows in database (0.003528s)

# 删除用户
taos> DROP USER hss;
Query OK, 0 of 0 rows affected (0.000756s)

taos> SHOW USERS;
           name           | super | enable | sysinfo |       create_time       |
================================================================================
 root                     |     1 |      1 |       1 | 2022-09-07 11:09:05.717 |
Query OK, 1 rows in database (0.001342s)


#授权
GRANT ALL ON test.* TO hss;

#撤销授权
REVOKE WRITE ON test.* FROM hss;

taos> GRANT ALL ON test.* TO hss;
Query OK, 0 of 0 rows affected (0.000712s)

taos> REVOKE WRITE ON test.* FROM hss;
Query OK, 0 of 0 rows affected (0.000622s)

• 基础创建语句

#超级表equ_data_log 
create table equ_data_log (ts timestamp,v1 FLOAT,v2 FLOAT,v3 FLOAT,content nchar(2000))
tags(fk_equ_id INT);

use anheiot_td;
insert into equ_data_log_20230913 using equ_data_log tags(10014)
values(now,-6.2652,6.45762,0.0000,'{}');

#超级表mqtt_data_log 
create table mqtt_data_log (ts timestamp,date_obj nchar(2000))
tags(equ_type INT,sensor_no nchar(100));

--channel,equ_type,sensor_no
insert into mqtt_data_log_100160 using mqtt_data_log tags('19','100160_19_undefined')
values (now, '{"org_id":"100160","equ_type":19,"net_code":"100160_19_undefined","equ_net_time":"2023-05-31 12:51:04"}');