[承上个问题] (Pyscript) 遇到“ModuleNotFoundError: No module named 'mysql'

这是我上个问题的连接:
http://t.csdn.cn/X2sFi

问题的更新:
当时讨论出来的解法是，确保远端的主机也有下载 "mysql-connector-python" 及 " MySQL-python"，就能解决 model not found error, 但目前情况还是有的

我已经确保我的 '网站伺服器电脑' 和 'MySQL 资料库电脑' 有做完 "pip install mysql-connector-python" 及 "pip install MySQL-python"

但报错还是一样的，也算庆幸报错没更新成别的
一样是 ModuleNotFoundError: No module named 'mysql'

  • 报错

    Traceback (most recent call last):
File "/lib/python3.10/site-packages/_pyodide/_base.py", line 435, in eval_code
.run(globals, locals)
File "/lib/python3.10/site-packages/_pyodide/_base.py", line 304, in run
coroutine = eval(self.code, globals, locals)
File "", line 1, in 
ModuleNotFoundError: No module named 'mysql'

  • 原.html 代码

    
  
    
    
  

  
    title test 1.10  
    
  
    

  
      import mysql.connector
      import pymysql

      mydb = mysql.connector.connect(
        host="196.168.100.141", # MySQL database IP address
        user="root",
        password="password123", 
        database="database_db",  
        auth_plugin='mysql_native_password'
      )
        
      mycursor = mydb.cursor()
      mycursor.execute("SELECT P_TITLE FROM webpage")                                                              
      myresult = mycursor.fetchall()
      list_01 = []
      
      for row in myresult:
        temp_val = row[0]
        list_01.append(temp_val)

  • online 网站 截图

img

所以需要专家的建议 ᶘ ᵒᴥᵒᶅ

确认有装 mysql.connector

>>> import mysql.connector
>>> print(mysql.connector.__version__)
8.0.31

在python 3.6下面

[root@localhost bin]# pip3 show mysql-connector-python
Name: mysql-connector-python
Version: 8.0.31
Summary: MySQL driver written in Python
Home-page: http://dev.mysql.com/doc/connector-python/en/index.html
Author: Oracle and/or its affiliates
Author-email:
License: GNU GPLv2 (with FOSS License Exception)
Location: /usr/local/lib/python3.6/site-packages
Requires: protobuf

目前已经有确认这些，但还是报一样的error，怎么处理好

根据连结
https://stackoverflow.com/questions/75092505/linux-python-still-face-modulenotfounderror-no-module-named-pymysql-aft#75092781
引用他的说法--
您使用的是 PyScript 框架，其中 Python 安装在第三方服务的服务器端，与您本地的 Python 安装无关。

因此，您应该按照 PyScript 的导入所需库的文档来声明您希望使用 py-config 标记安装的库：

<html>
    <head>
      <link rel="stylesheet" href="https://pyscript.net/latest/pyscript.css" />
      <script defer src="https://pyscript.net/latest/pyscript.js"></script>
    </head>
  <body>
    <b><p>title test 1.10-test_get_ print  </p></b>
    <br>
    <py-config>
      packages = ["pymysql", "mysql-connector-python"]
    </py-config>
    <py-script>
      import pymysql
      print (pymysql.__version__)
    </py-script>
  </body>
</html>

pip install mysql-connector

去远端主机， pip list 看看 mysql-connector 是否成功安装。