Python Forum

hii once again i need help i'm taking courses but just need a little help.
I have a made script that opens a file with data stored to read the file and connect to the database from out that txt file with eval
but now it opens and and start checken and it opens connection at first 3 lines in txt but it connects and print the 4 database in text

filepath = 'Results/sorted.txt'
with open(filepath) as lijst:
    for line in lijst:
        cnt = 1
        while line:
            try:
                connection = eval('MySQLdb.connect({})'.format(line.strip()))
                print("Line {}: {}".format(cnt, connection, line.strip()))
                line = lijst.readline()
                cnt += 1
                while cnt == + 1:
                    connection(cnt, line)
            except Error as e:
                print(e) 

Error:
C:\Users\Gebruiker\PycharmProjects\pythonProject\venv\Scripts\python.exe C:/Users/Gebruiker/Downloads/V1/test.py
Line 1: <_mysql.connection open to 'first line' at 0000026EB9D29640>
Line 2: <_mysql.connection open to 'second line' at 0000026EB9DB3FC0>
Line 3: <_mysql.connection open to 'third line' at 0000026EB9D29640>
(2002, "Can't connect to MySQL server on 'fourth line' (10060)")
(2002, "Can't connect to MySQL server on 'fourth line ' (10060)")
(2002, "Can't connect to MySQL server on 'fourth line' (10060)")

duplicate post
same as: https://python-forum.io/Thread-Need-Help...m-txt-file

hii i dont understand what you meant brother and is it normal i cant msg you?
any good good site for tut on python?
and i have now made small changes to my dbs connect file can you look at it for me and in small explain to me that if the program connects or not how continue to last dbs in opend file and not stop after check one

import MySQLdb
import MySQLdb._exceptions
import sys, os, requests


with open("datafile.txt", "r") as lijst:
            for line in lijst:
                lijst.readline
                connection = eval('MySQLdb.connect({})'.format(lijst.readline().strip()))
                print(connection)
               

Error:
C:\Users\Gebruiker\Downloads\V1>python3 *****.py
<_mysql.connection open to 'localhost' at **********>
Traceback (most recent call last):
  File "C:\Users\Gebruiker\Downloads\V1\****.py", line 8, in <module>
    connection = eval('MySQLdb.connect({})'.format(lijst.readline().strip()))
  File "<string>", line 1, in <module>
  File "C:\Users\Gebruiker\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\MySQLdb\__init__.py", line 130, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\Gebruiker\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\MySQLdb\connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2002, "Can't connect to MySQL server on 'localhost' (10060)")

Instead of creating a new thread on same subject, you should just add new posts to same thread.
It just keeps things neat and avoids confusion.
Please read: https://python-forum.io/misc.php?action=help&hid=22

I locked the other thread. Keep the discussion here. I decided not to merge threads because it will create even bigger confusion.