MySQL 引擎可以对存储在远程 MySQL 服务器上的数据执行 SELECT 查询报错？

Question

Code: 1000. DB::Exception: Received from localhost:9000. DB::Exception: Exception: Connections to all replicas failed: clickhouse@192.168.0.4:3306 as user root.

有没有碰到这个问题，MySQL 引擎可以对存储在远程 MySQL 服务器上的数据执行 SELECT 查询，报这个错。

Answer 1

提问者 年糕008 2021-07-18 08:31:32

Code: 1000. DB::Exception: Received from 192.168.0.72:9000. DB::Exception: Exception: Connections to all replicas failed: clickhouse@192.168.0.4:3306 as user root.

• Michael_PK #1

  clickhouse@192.168.0.4:3306 as user root.。
  mysql没有开启远程的赋权操作，需要在mysql中进行赋权，然后刷新