Skip to Content

Changes for page 2 Script

Last modified by Devin Chen on 2025/06/06 14:03
From version 62.1
edited by Theodore Xu
on 2023/08/24 17:27
Change comment: There is no comment for this version
To version 63.1
edited by Theodore Xu
on 2023/08/24 17:28
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1483,65 +1483,3 @@
1483 1483  [[image:image-20220709165402-21.png]]
1484 1484  
1485 1485  = **2.7 Mysql** =
1486 -
1487 -
1488 -
1489 -=== 1.Install Mysql software ===
1490 -
1491 -Download the latest version of Mysql.
1492 -
1493 -(% style="text-align:center" %)
1494 -[[image:Mysql的软件版本.png||height="673" width="894"]]
1495 -
1496 -=== 2.Navicat connect Mysql ===
1497 -
1498 -Connecting to Mysql with navicat.
1499 -
1500 -(% style="text-align:center" %)
1501 -[[image:连接到mysql.png]]
1502 -
1503 -=== 3.Create a database ===
1504 -
1505 -Character set should be choose utf8mb3/utf8mb4 and Collation choose utf8mb3_danish_ci/utf8mb4_danish_ci.
1506 -
1507 -(% style="text-align:center" %)
1508 -[[image:创建数据库.png||height="585" width="818"]]
1509 -
1510 -=== 4.Create a data table ===
1511 -
1512 -Create a table, enter the fields you need.
1513 -
1514 -(% style="text-align:center" %)
1515 -[[image:创建表1.png||height="484" width="737"]]
1516 -
1517 -Save, enter table name.
1518 -
1519 -(% style="text-align:center" %)
1520 -[[image:创建表2.png]]
1521 -
1522 -=== 5.Input Table Data ===
1523 -
1524 -(% style="text-align:center" %)
1525 -[[image:输入或者导入数据.png]]
1526 -
1527 -=== 6.Modifying scripts and debug：**[[Mysql script>>https://docs.we-con.com.cn/bin/view/V-BOX/V-Net/Manual/04%20Lua%20Script/01%20Lua%20Functions/\#H11MySQLdatabaseoperation]]** ===
1528 -
1529 -(% style="text-align:center" %)
1530 -[[image:调试结果.png]]
1531 -
1532 -=== 7.Problem ===
1533 -
1534 -During our debugging process it may there are some problems about Mysql， such as
1535 -
1536 -* MySQL: Host  192.168.XXX.XXX  is not allowed to connect.
1537 -* MySQL: Host  192.168.XXX.XXX  is blocked because of many connection errors.
1538 -* MySQL: SSL connection error: unknown error number.
1539 -* (((
1540 -1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist.
1541 -)))
1542 -
1543 -This type of problem has nothing to do with scripts or devices, it is a Mysql configuration issue. If you have any of these problems, please look for a solution online.
1544 -
1545 -{{info}}
1546 -✎Note: If you want to use CMD to access Mysql, you need to add the bin file to the environment variable, please check online for details of the operation.
1547 -{{/info}}