-1

Face recognition terminal iVMS-4200 shows an error when connecting to the mysql database. I tried like the following video on Youtube. But it's showing error while saving. Please help. I am attaching a picture.

1

2

https://www.youtube.com/watch?v=HoQy2yejzBI

I tried like this youtube video but I get the error like in the picture

markalex
  • 8,623
  • 2
  • 7
  • 32
Saidov Sanjar
  • 1
  • 2
  • I installed a virtual server "MAMP". It has MySQL version 5.7. I tried connecting to this server in Python. The connection was successful. But there is always an error in the iVMS program. – Saidov Sanjar Mar 20 '23 at 13:36
  • `import mysql.connector` `db = mysql.connector.connect(` `host = "localhost",` `user = "root",` `passwd = "root",` `database = "imron"` `)` `mycursor = db.cursor()` `mycursor.execute("SELECT * FROM nik")` `myresult = mycursor.fetchall()` `print(len(myresult))` *return 0* – Saidov Sanjar Mar 20 '23 at 13:51
  • I notice you are using the local loopback address in iVMS, but localhost in your python connection. Did you try localhost in iVMS? – user1191247 Mar 20 '23 at 19:32

1 Answers1

0

Try Mysql 5.0.45. it will work.

Learner
  • 16
  • 1