处理 Code:516. Authentication failed: password is incorrect or there is no user with such name.

这篇具有很好参考价值的文章主要介绍了处理 Code:516. Authentication failed: password is incorrect or there is no user with such name.。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

在测试 ClickHouse 分布式表时，创建分布式表成功，但是查询数据时报错，如下：

Received exception from server (version 22.2.2):
Code: 516. DB::Exception: Received from 192.168.38.101:9000. DB::Exception: Received from 192.168.38.103:9000. DB::Exception: default: Authentication failed: pass
word is incorrect or there is no user with such name. (AUTHENTICATION_FAILED)

code: 516. db::exception: default: authentication failed: password is incorr,clickhouse,数据库,数据仓库,数据库开发,数据库架构,dba

排查后发现，是集群开始安装时设置了密码，而配置分布式表时，没有添加各服务器的用户名和密码，所以访问不到别的服务器的数据，在我们的/etc/clickhouse-server/config.d/metrika.xml中，加入用户名和密码即可正常查询数据，如下：

<clickhouse_remote_servers>
<!--market_ck_cluster:for market business and Marketing platform-->
<market_ck_cluster>
    <shard>
        <internal_replication>true</internal_replication>
        <replica>
            <host>192.168.38.101</host>
            <port>9000</port>
            <user>default</user>
            <password>123456</password>

         <password_sha256_hex>8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92</password_sha256_hex>
        </replica>
        <replica>
            <host>192.168.38.102</host>
            <port>9000</port>
            <user>default</user>
<password>123456</password>          <password_sha256_hex>8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92</password_sha256_hex> 
       </replica>
    </shard>
    <shard>
        <internal_replication>true</internal_replication>
        <replica>
            <host>192.168.38.103</host>
            <port>9000</port>
            <user>default</user>
<password>123456</password>

            <password_sha256_hex>8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92</password_sha256_hex>
</replica>
    </shard>
</market_ck_cluster>
</clickhouse_remote_servers>

就是这两行：

 <user>default</user>
 <password>123456</password>

修改完成后，查询分布式成功：

node102 :) select dt ,count(id) from dbapi_db.dwd_middle_homework_students_correct_detail_1_all  group by dt order by dt;

SELECT
    dt,
    count(id)
FROM dbapi_db.dwd_middle_homework_students_correct_detail_1_all
GROUP BY dt
ORDER BY dt ASC

Query id: 1409ea4e-0f74-417d-9026-8409a2e4e887

┌─dt─────────┬─count(id)─┐
│ 2022-06-09 │    522346 │
│ 2022-06-10 │    460020 │
└────────────┴───────────┘

2 rows in set. Elapsed: 0.052 sec. Processed 982.37 thousand rows, 51.08 MB (19.05 million rows/s., 990.39 MB/s.)

问题解决，开始开心的学习.....文章来源地址https://www.toymoban.com/news/detail-583293.html

到了这里，关于处理 Code:516. Authentication failed: password is incorrect or there is no user with such name.的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！