Das deutsche Python-Forum

Code: Alles auswählen

from mysql.connector import (connection)

Servername = --Hier kommt der Servername hin--
Benutzer   = --Hier kommt der Benutzername hin--
Passwort   = --Hier kommt das Passwort hin--
Datenbank  = --Hier kommt der Datenbankname hin--


try:
  cnx = connection.MySQLConnection(user=Benutzer, password=Passwort,
                                 host=Servername,
                                 database=Datenbank)
except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with your user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exist")
  else:
    print(err)
else:
  cnx.close()

Code: Alles auswählen

Traceback (most recent call last):
  File "/home/lonnieschemann/.local/lib/python3.10/site-packages/mysql/connector/network.py", line 574, in open_connection
    self.sock.connect(sockaddr)
TimeoutError: [Errno 110] Connection timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/lonnieschemann/Schreibtisch/schemannKurierEmail.py", line 9, in <module>
    cnx = connection.MySQLConnection(user=Benutzer, password=Passwort,
  File "/home/lonnieschemann/.local/lib/python3.10/site-packages/mysql/connector/connection.py", line 116, in __init__
    self.connect(**kwargs)
  File "/home/lonnieschemann/.local/lib/python3.10/site-packages/mysql/connector/abstracts.py", line 1052, in connect
    self._open_connection()
  File "/home/lonnieschemann/.local/lib/python3.10/site-packages/mysql/connector/connection.py", line 494, in _open_connection
    self._socket.open_connection()
  File "/home/lonnieschemann/.local/lib/python3.10/site-packages/mysql/connector/network.py", line 576, in open_connection
    raise errors.InterfaceError(
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'sql107.epizy.com:3306' (110 Connection timed out)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3.10/idlelib/run.py", line 578, in runcode
    exec(code, self.locals)
  File "/home/lonnieschemann/Schreibtisch/schemannKurierEmail.py", line 12, in <module>
    except mysql.connector.Error as err:
NameError: name 'mysql' is not defined