das Aufbauen einer DB-Verbindung (MariaDB) per pymysql funktioniert nur wenn ich als host = localhost angebe.
Also, das funktioniert:
Code: Alles auswählen
import pymysql
connection = pymysql.connect(host='localhost',
user='USERNAME',
password='PASSWORD',
db='DBNAME'
)
Code: Alles auswählen
import pymysql
connection = pymysql.connect(host='192.168...',
user='USERNAME',
password='PASSWORD',
db='DBNAME'
)
Code: Alles auswählen
Traceback (most recent call last):
File "/home/earloop/test.py", line 15, in <module>
db='Test'
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 353, in __init__
self.connect()
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 632, in connect
self._get_server_information()
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 1055, in _get_server_information
packet = self._read_packet()
File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 707, in _read_packet
% (packet_number, self._next_seq_id)
pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 0