(Pyscript) website showing No module named 'mysql' #425

jtoncrise00300 · 2023-01-09T08:42:10Z

jtoncrise00300
Jan 9, 2023

I'm uploading the following .html to WinSCP, but facing ModuleNotFoundError: No module named 'mysql'

html script

<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 <u><label id="AAA"></label></u> </p></b>
    <br>
  



    <py-script>
        import mysql.connector

        mydb = mysql.connector.connect(
          host="196.168.100.141",
          user="root",
          password="password123", 
          database="database_db",  
          auth_plugin='mysql_native_password'
        )
                        
        mycursor = mydb.cursor()
        mycursor.execute("SELECT row_01 FROM database")                       
                                                 
        myresult = mycursor.fetchall()
        
        list_01 = []
        
        for row in myresult:
          temp_val = row[0]
          list_01.append(temp_val)
    </py-script>
  </body>
</html>

error message

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 "<exec>", line 1, in <module>
ModuleNotFoundError: No module named 'mysql'

pic: the ModuleNotFoundError on online website

I already do pip install mysql on my pc, but online website still get this error, so where show I pip install or what shall I do

watermarkhu · 2023-01-13T21:00:59Z

watermarkhu
Jan 13, 2023

Wrong pyscript. This is the custom integration for Home Assistant. What you are looking for is this.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

(Pyscript) website showing No module named 'mysql' #425

{{title}}

Replies: 1 comment

{{title}}

Select a reply

(Pyscript) website showing No module named 'mysql' #425

jtoncrise00300 Jan 9, 2023

Replies: 1 comment

watermarkhu Jan 13, 2023

jtoncrise00300
Jan 9, 2023

watermarkhu
Jan 13, 2023