MYSQL: "Access denied for user 'X'@'localhost' (using password: YES)" PYTHON

Question

I'm trying to access the database using python but it's just not working. When I access a remote database everything is fine. But local there is some kind of problem. What I'm doing wroing here? I've tryied some things that I found on intener do grant access but they did not work

Local users:

Code used:

Message recieved

Thanks for the help

Answer 1

After hours of testing I finally found out what was the problem! After some alterations in the mysql users and no results everything work just fine when I added the PORT to mysql database!

db = MySQLdb.connect(host="127.0.0.1",user="userpython",passwd="root",db="bigdata",port=8886)