Python can't connect to MySQL db: OperationalError

Question

When in the Python shell I type:

import MySQLdb
Con = MySQLdb.Connect(user='testuser', password='password', db='test')

And I get this:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Users\Nickey\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\__init__.py", line 86, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\Nickey\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py", line 204, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2059, <NULL>)

And no description of the error at all. Please, I am waiting for help. Thanks.

UPDATE: In case somebody will be having this problem, it appears to be connected with the new mysql_auth_plugin, with its new Strong Password Encryption for Authentication. I just switched to old_password_plugin(Legacy Authentication Method) in the configuration of MySQL Server and now [All works!].

eagle · Accepted Answer · 2018-05-09 15:03:50Z

2

According to the docs, password is not a keyword argument like you entered, instead it's passwd as you can see --> here

answered May 9, 2018 at 15:03

eagle

9006 silver badges14 bronze badges

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

1 Comment

Nickey Production Over a year ago

I have changed keyword argument to passwd and got the same result. Actually, if i type just Con = MySQLdb.Connect() without any argument I get the same OperationalError(2059, <NULL>)

Collectives™ on Stack Overflow

Python can't connect to MySQL db: OperationalError

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related