clickhouse 客户端工具

张映 发表于 2021-08-25

分类目录: clickhouse

标签:, ,

推荐三款工具都是跨平台的,mysql命令行,dbeaver,tabix。

1,mysql命令行

<mysql_port>9004</mysql_port>

在config.xml中添加mysql端口,重启clickhouse后,就可以登录了。

[tidb@testticdc ~]$ mysql -u default -p -h 10.0.10.23 -P 9004
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 20.8.3.18-ClickHouse 0

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> show databases;
+--------------------------------+
| name                           |
+--------------------------------+
| _temporary_and_external_tables |
| default                        |
| netjoytest                     |
| netjoytest1                    |
| system                         |
+--------------------------------+
5 rows in set (0.00 sec)

MySQL [(none)]> use netjoytest1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MySQL [netjoytest1]> show tables;
+-----------+
| name      |
+-----------+
| tank1     |
| tank1_all |
| tanktest  |
| tanktest2 |
| tanktest3 |
| tanktest4 |
+-----------+
6 rows in set (0.00 sec)

MySQL [netjoytest1]> select * from tank1_all limit 2;
+------+------+------+---------------------+
| id   | name | age  | create_time         |
+------+------+------+---------------------+
|    2 | tank |    0 | 2021-08-23 14:21:30 |
|    3 | tank |    0 | 2021-08-23 14:21:30 |
+------+------+------+---------------------+
2 rows in set (0.01 sec)

像navicate,hedisql,sequel pro等都可以连,不过图形界面点不了,只能sql查询。

2,dbeaver客户端工具,这个工具很强大,推荐使用

dbeaver

dbeaver

3,tabix有点类似于phpmyadmin

下载:git clone https://github.com/tabixio/tabix.git

配置nginx

[root@localhost vhosts]# cat ck.conf
    server {
        listen 10090;
        server_name 10.0.50.20;
        charset        utf-8;
        root /root/tabix/build;
        location / {
            if (!-f $request_filename) {
                rewrite ^(.*)$ /index.html last;
            }
            index  index.html index.htm;
        }
    }
tabix

tabix



转载请注明
作者:海底苍鹰
地址:http://blog.51yip.com/clickhouse/2524.html

留下评论

留下评论
  • (必需)
  • (必需) (will not be published)
  • (必需)   1X3=?