目前使用环境：
server：ubuntu 16.04 + mysql 5.7 +phpmyadmin
在有固定ip的NAT 下，3306 PORT 有开
MYSQL的IP 限制也全部关闭了(所有IP 都可连)
另外有一片7688duo 负责收集传感器资料，用pymysql回传资料
之前测试都是在区网下，资料都能正常丢进数据库内
但是一把数据库放到外网上，资料就丢不回去
max_allowed_packet 已经改成64M 了
程式码：https://www.codepile.net/pile/kPY6lxz7
错误资讯：
Traceback (most recent call last):
File "sql-internet.py", line 11, in <module>
db="cultivator-test")
File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in
Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 325,
in __init__
self.connect()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 598,
in connect
self._get_server_information()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 975,
in _get_server_information
packet = self._read_packet()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 657,
in _read_packet
packet_header = self._read_bytes(4)
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 699,
in _read_bytes
"Lost connection to MySQL server during query (%s)" % (e,))
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during
query ([Errno 131] Connection reset by peer)')
另外想请教用google chart，如果想要图表可以自动更新(不要刷新网页)
一定要用到jquery之类的功能吗，或是有其他可以单纯的js就能解决？