Skip to Content

Changes for page 2 Script

Last modified by Devin Chen on 2025/06/06 14:03
From version 68.1
edited by Theodore Xu
on 2023/08/25 09:29
Change comment: There is no comment for this version
To version 64.1
edited by Theodore Xu
on 2023/08/25 09:08
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1483,63 +1483,3 @@
1483 1483  [[image:image-20220709165402-21.png]]
1484 1484  
1485 1485  == **2.7 Mysql** ==
1486 -
1487 -=== 1.Install Mysql software ===
1488 -
1489 -Download the latest version of Mysql.
1490 -
1491 -(% style="text-align:center" %)
1492 -[[image:Mysql的软件版本.png]]
1493 -
1494 -=== 2.Navicat connect Mysql ===
1495 -
1496 -Connecting to Mysql with navicat.
1497 -
1498 -(% style="text-align:center" %)
1499 -[[image:连接到mysql.png]]
1500 -
1501 -=== 3.Create a database ===
1502 -
1503 -Character set should be choose utf8mb3/utf8mb4 and Collation choose utf8mb3_danish_ci/utf8mb4_danish_ci.
1504 -
1505 -(% style="text-align:center" %)
1506 -[[image:创建数据库.png]]
1507 -
1508 -=== 4.Create a data table ===
1509 -
1510 -Create a table, enter the fields you need.
1511 -
1512 -(% style="text-align:center" %)
1513 -[[image:创建表1.png]]
1514 -
1515 -Save, enter table name.
1516 -
1517 -(% style="text-align:center" %)
1518 -[[image:创建表2.png]]
1519 -
1520 -=== 5.Input Table Data ===
1521 -
1522 -(% style="text-align:center" %)
1523 -[[image:输入或者导入数据.png]]
1524 -
1525 -=== 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]]** ===
1526 -
1527 -(% style="text-align:center" %)
1528 -[[image:调试结果.png]]
1529 -
1530 -=== 7.Problem ===
1531 -
1532 -During our debugging process it may there are some problems about Mysql， such as
1533 -
1534 -* MySQL: Host  192.168.XXX.XXX  is not allowed to connect.
1535 -* MySQL: Host  192.168.XXX.XXX  is blocked because of many connection errors.
1536 -* MySQL: SSL connection error: unknown error number.
1537 -* (((
1538 -1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist.
1539 -)))
1540 -
1541 -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.
1542 -
1543 -{{info}}
1544 -✎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.
1545 -{{/info}}
Mysql的软件版本.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -78.4 KB
Content
创建数据库.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -53.2 KB
Content
创建表1.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -49.0 KB
Content
创建表2.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -18.4 KB
Content
调试结果.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -68.4 KB
Content
输入或者导入数据.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -26.6 KB
Content
连接到mysql.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -59.0 KB
Content
连接数据库1.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -56.5 KB
Content
连接数据库2.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.AiXia
Size
... ... @@ -1,1 +1,0 @@
1 -25.5 KB
Content