Cannot connect to MySQL in Python program

Question

I am trying to establish a connection with a MySQL database in a python program

import mysql.connector
cnx = mysql.connector.connect(
    host='localhost',
    user='admin',
    password='admin1234',
    database='meu_banco'
)
cnx.close()

print(cnx)

but keep getting the following error:

mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Im am pretty sure that the username is admin and that I've setted 'admin1234' as the password. Anyone knows what might be happening?

Notes:

-I've also tried to use 'passwd' and 'db' instead of 'password' and 'database' keyword arguments.

-I'm using MySQL that comes with XAMPP version 8.0.2 / PHP 8.0.2 for Linux.

What do you mean by "I am pretty sure the username is admin". Did you set the username as admin or you are guessing it is admin? PS: As the error says, it looks like an error resulting from invalid credentials... — Swetank Poddar
– Swetank Poddar, Commented Feb 19, 2021 at 9:22
Oh I'm sorry for the inaccurate explanation. I meant that wrong credentials are not the cause of the problem. I am 100% sure that e set the username and password as above. — Juliano Amadeu
– Juliano Amadeu, Commented Feb 19, 2021 at 10:52

ad absurdum · Accepted Answer · 2021-02-19 12:03:27Z

1

You are connecting to the database and afterwards you are closing the connection.

Only use cnx.close() when you want to close the database connection, it may cause an error.

If that's not the problem, you may have the user wrong, try to use the default username that MySQL Workbench has, it is root.

edited Feb 19, 2021 at 12:03

ad absurdum

22.1k5 gold badges45 silver badges67 bronze badges

answered Feb 19, 2021 at 9:14

Ricardo Sevilla

365 bronze badges

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

Collectives™ on Stack Overflow

Cannot connect to MySQL in Python program

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related