For a university project I rented a server to run a MySQL database on it. In Python, I connect to the server via SSH (I know, not the best solution) and try to insert values into a table in the database. If I run the statement and then directly (in my Python program), I get back the inserted value. If I run my program a second time without the statement, the value is not displayed. Also, when I look in the database table, the value was not inserted.
Here my code:
Solution:
Add to database connection
