ClickHouse创建mysql数据库引擎报错【Code: 501】

使用clickhouse的数据库引擎mysql创建一个库用来同步mysql中的数据，命令如下：

CREATE DATABASE mysql_db ENGINE = MySQL('localhost:3306','click_test','root','123456');

结果报如下错误：

CREATE DATABASE mysql_db
ENGINE = MySQL('localhost:3306', 'click_test', 'root', '123456')


Received exception from server (version 20.6.6):
Code: 501. DB::Exception: Received from localhost:9000. DB::Exception: Cannot create MySQL database, because Poco::Exception. Code: 1000, e.code() = 2002, e.displayText() = mysqlxx::ConnectionFailed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ((nullptr):0),

解决办法：

连接clickhouse-server的时候，不要使用localhost，使用127.0.0.1代替：

CREATE DATABASE mysql_db ENGINE = MySQL('127.0.0.1:3306','click_test','root','123456');