mysql连接clickhouse_通过mysql操作clickhouse

mysql软件安装

至少需要安装一个mysql客户端，即要有mysql这个命令；也可以直接安装一个mysql数据库，不用可以不启动；

clickhouse服务端配置mysql端口

vim /etc/clickhouse-server/config.xml

9004

修改服务器端配置，需要重启clickhouse, 默认日志输出 /var/log/clickhouse-server/clickhouse-server.log

下面这种方式，需要在本地配置mysql，然后本地连接，默认省去的连接主机为localhost

[root@ch2 ~]# mysql --protocol tcp -u default -P 9004Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection idis 0Server version:20.3.9.70-ClickHouse

Copyright (c)2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

mysql>show databases;+---