Connect to MySQL database using python

Question

So I am having a super hard time connecting to a local database using the python mysql.connector module.

So I am trying to connect using the highlighted connection. I use the password abcdefghijkl to log into the SQL environment. I am trying to connect to a database named flight_school.

My python script looks like so.

import mysql.connector

mydb = mysql.connector.connect("localhost", "root", "abcdefghijkl", "flight_school")

print(mydb.is_connected())

This above code in the arguments in the following order i.e.

hostname = localhost,
user = 'root',
password = 'abcdefghijkl', and
database name = 'flight_school'.

It's just not working. I get the following error.

I would really appreciate some advice, please.

nbk · Accepted Answer · 2024-04-04 07:33:19Z

3

Please read always the official documentation

Your connection string has to have this form(if you do it this way)

 mydb = mysql.connector.connect(
     host="localhost",
     user="root",
     passwd="testpaaword",
     database="testdb"
 )

edited Apr 4, 2024 at 7:33

answered Apr 30, 2020 at 0:15

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

3 Comments

chintan thakrar Over a year ago

I tried implementing the way you stated like so. mydb = mysql.connector.connect(host="localhost", user="root", passwd="abcdefghijkls", database="flight_school") But I keep on getting an error like so mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

chintan thakrar Over a year ago

Any clue what that might mean

nbk Over a year ago

yes you have to enable in the mysql_native_password on your mysql server or for the user that logs in

Samuel Calado · Accepted Answer · 2022-11-17 10:28:15Z

Please read always the official documentation: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html

import mysql.connector
from mysql.connector import errorcode, MySQLConnection

try:
    db_connection = MySQLConnection(user='root', password='', port='3306', database='your_database')
    print("Database connection made!")
except mysql.connector.Error as error:
    if error.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database doesn't exist")
    elif error.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("User name or password is wrong")
    else:
        print(error)
else:
    db_connection.close()

cursor = db_connection.cursor()

sql = ("commands")
cursor.execute(sql)

Angry_Coder · Accepted Answer · 2020-04-30 00:14:52Z

-1

Check out SQL-Alchemy module, works wonders from my experience.

answered Apr 30, 2020 at 0:14

Angry_Coder

11 bronze badge

Collectives™ on Stack Overflow

Connect to MySQL database using python

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related