blocks|key|2264981|text|import+mysql.connector
def+connection():
++++conn+=+mysql.connector.connect(host+=+"XXXXX",
++++++++++++++++++user+=+'XXXXX',
++++++++++++++++++password+=+'XXXXX',
++++++++++++++++++database+=+'login_page',
++++++++++++++++++auth_plugin='mysql_native_password')

++++c+=+conn.cursor()
++++return+c+,+conn|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2264982|下载mysql连接器而不是pymysql，并尝试以这种方式进行连接。它对我有效，希望它也对你有用。|unstyled|2264983|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>import mysql.connector
def connection():
 conn = mysql.connector.connect(host = "XXXXX",
 user = 'XXXXX',
 password = 'XXXXX',
 database = 'login_page',
 auth_plugin='mysql_native_password')

 c = conn.cursor()
 return c , conn
</code></pre>

Download mysql connector rather than pymysql and try connecting this way. It worked for me, hope it works for u too.

blocks|key|76118|text|错误信息可以变得更全面，更有帮助。为了修复这个“加密”包，需要安装。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|76119|pip+install+cryptography|code-block|syntax|javascript|76120|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The error message can be made more comprehensive and helpful. In order to fix this "cryptography" package needs to be installed.

<pre><code>pip install cryptography
</code></pre>

blocks|key|76136|text|要使用“sha256_password”或“caching_sha2_password”进行身份验证，需要安装额外的依赖项：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|76137|$+python3+-m+pip+install+PyMySQL[rsa]|code-block|syntax|javascript|76138|来源：https://pymysql.readthedocs.io/en/latest/user/installation.html|offset|length|76139|entityMap|0|LINK|mutability|MUTABLE|url|https://pymysql.readthedocs.io/en/latest/user/installation.html^0|0|0|3|1R|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

To use “sha256_password” or “caching_sha2_password” for authenticate, you need to install additional dependency:

<pre><code>$ python3 -m pip install PyMySQL[rsa]
</code></pre>

Source: <a href="https://pymysql.readthedocs.io/en/latest/user/installation.html" rel="noreferrer">https://pymysql.readthedocs.io/en/latest/user/installation.html</a>

blocks|key|946823|text|值得注意的是，我今天在使用MySQL中的SQLAlchemy时遇到了这个问题。原来我用错了这个账户的密码。换句话说，如果您有此问题，您可能需要首先确认您使用的密码是正确的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|946824|FWIW，我不知道为什么这会产生密码信息。沿途有什么问题吗？|946825|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

For what it's worth, I had this problem today using MySQL via SQLAlchemy in Python. It turned out that I was using the wrong password for this account. In other words, if you have this problem, you might want to start by just confirming that you're using the correct password.

FWIW, I am not sure why this generated a cryptography message. Something buggy along the way?

blocks|key|2265249|text|“这份报告意味着sha256_password和caching_sha2_password这两种加密算法需要使用加密技术。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2265250|虽然含义很清楚，但你可能不知道如何解决它。|2265251|实际上，密码学是一个python包，所以解决方案很简单：“|offset|length|style|BOLD|2265252|尝试在您的cmd或终端上运行pip+install+cryptography。|CODE|2265253|这是来源。|2265254|entityMap|0|LINK|mutability|MUTABLE|url|https://www.programmersought.com/article/28861270139/^0|0|0|4|3|0|E|O|0|2|2|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@$F|Z|G|10|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@$F|12|G|13|H|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|14|8|@]|9|@$F|15|G|16|1|17]]|A|$]]|$1|O|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

&quot;This report means that sha256_password with caching_sha2_password These two encryption algorithms need to use cryptography. 
Although the meaning is clear, you may not know how to solve it. 
Actually, cryptography is a python package, so the solution is simple:&quot;
Try running <code>pip install cryptography</code> on you cmd or terminal. 
Here is the <a href="https://www.programmersought.com/article/28861270139/" rel="noreferrer">source</a>.

blocks|key|946856|text|今天，我在Python中使用MySQL通过SQLAlchemy也遇到了这个问题。只要通过mysql+-u根-p登录到数据库，它就消失了。请归功于“Ben”的暗示。很有可能发生了什么事。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|946857|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I also had this problem today using MySQL via SQLAlchemy in Python. It went away just by logging into the database via mysql -u root -p. Credit to @Ben for the hint. Something buggy may well be happening.

blocks|key|946859|text|我收到这条消息是因为我的数据库还没有启动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|946860|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I got the message because my database hadn't been started.

blocks|key|946844|text|我也遇到了这个问题。当我试图解决MySQL工作台中@brcmipn的使用方法时，它告诉我MySQL运行在我使用的超级安全Mode.So中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|946845|SET+GLOBAL+READ_ONLY+=+OFF;|code-block|syntax|javascript|946846|之后问题就不会再发生了。|946847|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I met this problem too. When I try to solve the problem use method of @brcmipn in MySQL Worbench, it tells me MySQL is running in Super Safe Mode.So I use

<pre><code>SET GLOBAL READ_ONLY = OFF;
</code></pre>

and after that the problem don't happen again.

blocks|key|2265162|text|在MYSQL工作台上轻松。创建一个新的MySQL用户，并使用您的IP填充“主机匹配的限制”。默认为%25。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2265163|在这里输入图像描述|offset|length|2265164|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/2CTqY.png^0|0|0|9|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Easy on MYSQL Workbench. Create a new MySQL user and fill the "Limit to Host Matching" with your IP. Is % by default.

<a href="https://i.stack.imgur.com/2CTqY.png" rel="nofollow noreferrer">enter image description here</a>

blocks|key|945518|text|降级，然后升级PyMySQL对我起了作用。在过去的几天里，我在Ubuntu+20+&+22上发生了两次这样的事情。我已经把所有的东西都安装好了，前一天所有的东西都在工作。下面是所发生的事情：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|945519|PyMySQL+1.0.2+-昨天工作，今天密码错误失败|945520|降级为0.9+-工作，没有密码错误|945521|升级到1.0.2+-+works|945522|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Downgrading then upgrading PyMySQL worked for me. This happened to me twice in the last few days, on Ubuntu 20 &amp; 22. I already had everything installed, and everything had been working the day before. Here's what happened:
PyMySQL
1.0.2 - was working yesterday, failed today with crypto error
downgrade to
0.9 - works, no crypto error
upgrade back to
1.0.2 - works

Good day. Hope your all are well. Can someone help me with fix this? 

I'm new to the MySQL environment. I'm trying to connect to MySQL Database remotely. I used the following python code and got this error. 

<pre><code>Print(e) = "cryptography is required for sha256_password or 
 caching_sha2_password"
</code></pre>

And have no idea how to solve the error.

<pre><code>import pymysql as db

HOST = "XXXXX.XXX.XX”
PORT = XXXX
USER = "my_username"
PASSWORD = "my_password”
DB = "db_name"

try:
 connection = db.Connection(host=HOST, port=PORT,user=USER, 
 passwd=PASSWORD, db=DB)

 dbhandler = connection.cursor()
 dbhandler.execute("SELECT * from table_name")
 result = dbhandler.fetchall()
 for item in result:
 print (DB)
 except Exception as e:
 print(e)

finally:
 connection.close()
</code></pre>

"cryptography is required for sha256_password or caching_sha2_password"

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

日安。希望你们一切都好。有人能帮我解决这个问题吗？我对MySQL环境很陌生。我正在尝试远程连接到MySQL数据库。我使用了下面的python代码并得到了这个错误。Print(e) = "cryptography is required for sha256_password or              caching_sha2_password"也不知道如何解决这个错误。import pymy

问“sha256_password或caching_sha2_password需要密码学”
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问“sha256_password或caching_sha2_password需要密码学”EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问“sha256_password或caching_sha2_password需要密码学”
EN