我试图使用python连接到使用MariaDB的数据库,我在MariaDB网页上使用了脚本,但是导入MariaDB模块时出错。如果我尝试手动导入它,就会得到相同的错误消息。这是一个脚本:
# Module Imports
import mariadb
import sys
# Connect to MariaDB Platform
try:
conn = mariadb.connect(
user="root",
password="password",
host="10.0.0.2",
port=65500,
database="main_db"
)
except mariadb.Error as e:
print(f"Error connecting to MariaDB Platform: {e}")
sys.exit(1)
# Get Cursor
cur = conn.cursor()这是错误消息:
Traceback (most recent call last):
File "c:\path\to\myenv\scripts\connectdb.py", line 2, in <module>
import mariadb
ModuleNotFoundError: No module named 'mariadb'在此之前,我检查了是否正确安装了mariadb:
C:\Users\user>pip install mariadb
Requirement already satisfied: mariadb in c:\users\user\appdata\local\packages\pythonsoftwarefoundation.python.3.10_qbz5n2kfra8p0\localcache\local-packages\python310\site-packages (1.0.11)
WARNING: There was an error checking the latest version of pip.
C:\Users\user>pip3 install mariadb
Requirement already satisfied: mariadb in c:\users\user\appdata\local\packages\pythonsoftwarefoundation.python.3.10_qbz5n2kfra8p0\localcache\local-packages\python310\site-packages (1.0.11)
WARNING: There was an error checking the latest version of pip.还试图将mariadb文件夹从自动安装的位置移到我的"connectdb.py“文件所在的文件夹中,但结果相同,但又出现了一个错误:
Traceback (most recent call last):
File "c:\users\user\documents\pyth\last_connect.py", line 2, in <module>
import mariadb
File "c:\users\user\documents\pyth\mariadb\__init__.py", line 10, in <module>
from ._mariadb import (
ModuleNotFoundError: No module named 'mariadb._mariadb'
>>>
---------- FINISHED ----------
exit code: 2 status: 0发布于 2022-10-24 16:28:23
您可能安装了两个不同的python解释器。检查是否在代码编辑器中选择了正确的。
https://stackoverflow.com/questions/74183866
复制相似问题