Ninatumia maktaba ya mysql-connector-python ya mysql, kujaribu kuunganisha kwenye hifadhidata ya MariaDB ya vifaa vingine ndani ya mtandao wa eneo, lakini imeshindikana, na inatoka moja kwa moja bila kutoa ujumbe wowote wa makosa.
Maelezo ya tatizo Toleo la programu:
MariaDB server 10.11.6
mysql-connector-python 9.2.0
MariaDB server, IP ni 192.168.1.60
Mteja, IP ni 192.168.1.35
Msimbo wa Python ni kama ifuatavyo:
import mysql.connector import logging # Sanidi kumbukumbu ya magogo logging.basicConfig(level=logging.DEBUG, format='%(asctime)s - %(levelname)s - %(message)s') try: logging.info("Inaunganisha kwenye hifadhidata...") connection = mysql.connector.connect( host="192.168.1.60", port=3306, user="mysql", password="xxx") logging.info("Muunganisho umeanzishwa.") # Unda kitu cha kishale, kinachotumika kutekeleza maswali ya SQL cursor = connection.cursor() # Pata hifadhidata zote logging.info("Inatekeleza swali la SHOW DATABASES...") cursor.execute("SHOW DATABASES") # Chapisha hifadhidata zote na majina ya jedwali katika kila hifadhidata for (database,) in cursor.fetchall(): logging.info(f"Hifadhidata: {database}") # Badilisha hadi hifadhidata ya sasa cursor.execute(f"USE {database}") # Pata na uchapishe majedwali yote katika hifadhidata ya sasa cursor.execute("SHOW TABLES") for (table,) in cursor.fetchall(): logging.info(f" Jedwali: {table}") # Funga kishale na muunganisho cursor.close() connection.close() logging.info("Muunganisho umefungwa.") except mysql.connector.Error as err: logging.error(f"Hitilafu: {err}") except Exception as e: logging.error(f"Hitilafu isiyotarajiwa: {e}") Baada ya kuendesha msimbo huu, inatoka moja kwa moja bila kutoa ujumbe wowote wa makosa.
...