Why I am unable to create connection with MySQL using python

Question

The program terminates automatically without throwin any error or output

The port and connector working fine and details are given below

C:\Users\jsr>pip list
Package                Version
---------------------- -------
mysql-connector-python 9.1.0
pip                    24.3.1

C:\Users\jsr>netstat -an | findstr 3306
  TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:33060          0.0.0.0:0              LISTENING
  TCP    [::]:3306              [::]:0                 LISTENING
  TCP    [::]:33060             [::]:0                 LISTENING

Python code-

import mysql.connector
from mysql.connector import Error

HOST = "localhost"
PORT = 3306
USER = "sud0077"
PASSWORD = "Admin@123"
DATABASE = "QuizzApp"

try:
    mydb = mysql.connector.connect(
        user=USER,
        password=PASSWORD,
        host=HOST,
        port=PORT,
        database=DATABASE
    )
    if mydb.is_connected():
        print("Connection successful")
except Error as e:
    print(f"Error: {e}")
finally:
    try:
        if mydb.is_connected():
            mydb.close()
            print("Connection closed")
    except NameError:
        print("Connection was never established")

Server is also running on port 3306. Id and pass is also correct but still no output terminal just gets closed while connecting and IDLE restarts automatically.

why aint you using a framework like django for python and mysql? Django for example comes with ORM capabilities and migrations and you dont have to initialize db connectors like you are doing i guess — pumpkin
– pumpkin, Commented Jan 3 at 20:56
There's no way this can run without printing something. It should either print the sucess messages or the error messages. — Barmar
– Barmar, Commented Jan 3 at 20:57
There's little need to test if mydb.is_connected():. If it can't connect, it will raise an exception. — Barmar
– Barmar, Commented Jan 3 at 20:58
First: You try to connect to the database via CLI using the data that you put on your script? Like the host, user, password and dbname? Second: Remove the "finally" and try again — Ramon
– Ramon, Commented Jan 3 at 21:00
Do not use the admin password in any app. You would do well to set up access for that single app, with its own username, password, and table set. Also, check this answer: stackoverflow.com/questions/12600985/… — duffymo
– duffymo, Commented Jan 4 at 0:02

Reece · Accepted Answer · 2025-01-03 23:58:34Z

0

I tried to run the same code locally and it worked fine for me:

Try to execute the script directly from PowerShell using the following command:

python mysql.py

To ensure that the problem is not the IDLE shell.

edited Jan 3 at 23:58

Reece

7641 gold badge11 silver badges26 bronze badges

answered Jan 3 at 21:04

Youssef Zraiba

245 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

sud0074 Jan 4 at 6:13

I know its running on every single system, even my friends laptop too, but why not on my laptop .. i am really worried me and my friends tried every single possibilities, but in last, its not working :(

Youssef Zraiba Jan 4 at 8:03

Did you tried to execute the script directly from PowerShell?

sud0074 Jan 4 at 8:24

YES for more details I have shared i video link it will gives you clear picture that I am facing youtu.be/3vFn4vrDJEM

Collectives™ on Stack Overflow

Why I am unable to create connection with MySQL using python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related