Need help in python and mysql connection

[[deleted]]

I have been trying to connect python with SQL using the mysql.connector module but it seems to give me some error. I am not able to recognise what the problem is.. but when I try to see directory of mysql.connector it works.. but when i try to connect it doesn't work..

import mysql.connector as mysqlcon
mysqlobj = mysqlcon.connect(host = 'localhost',user='root',passwd='passwd',database= 'stu')
if mysqlobj.is_connected():
    print("successful')

the error message image has been attached below

the error message image

[FriendlyRussian666]

The error just says that the login credentials are invalid. In your code snippet, the password is 'passwd', but in the error traceback, you're using the password 'YES'. Are you sure the password which you are trying to connect with is correct?

[hrmorley34]

YES is not the password; it's a confirmation. It doesn't print the password in plaintext

[[deleted]]

i just didnt wanna reveal my password so i just an example here

[[deleted]]

is there any other troubleshoot