Question 411415 in Mysql Question posted in
The official MySQL documentation can be found here.

Error When Connecting to MySQL Database in Python

I’m trying to connect to a MySQL database using Python with the mysql-connector library, but I keep running into an error. Here’s the code I’m using:
python
import mysql.connector

try:

connection = mysql.connector.connect( host='localhost', user='myuser', password='mypassword', database='mydatabase' )

print("Connection successful")

except mysql.connector.Error as err:

print(f"Error: {err}")

When I run this code, I receive the following error:

sql
Error: 1045 (28000): Access denied for user ‘myuser’@’localhost’ (using password: YES)
Verified that my username and password are correct.
Checked that the MySQL server is running and accessible.
Ensured that the user has permissions for the database.
Questions:

What could be causing this access denied error?
How can I troubleshoot this issue further?
Any help would be greatly appreciated!

Tags:

3

Answers


  1. 0

    Make sure the user has the appropriate permissions to the database. You can do this by logging in as root and executing:

    GRANT ALL PRIVILEGES ON mydatabase.* TO ‘myuser’@’localhost’;
    FLUSH PRIVILEGES;

    Login or Signup to reply.
  2. 0

    the problem could accure because of few things.
    1- make sure that the username and password you are using is correct
    2- if you use MySQL 8, it uses caching_sha2_password by default try to change it mysql_native_password plugin.
    3- maybe your user name "myuser" might not have permissions to connect from localhost

    Login or Signup to reply.
  3. 0

    Recheck your Database hostname, database user, passowrd, database name.
    here is sample user name input your real credential.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search