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

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