Damian
Reputation: 120
can't connect to MySQL by old secure_auth
I'm trying make a external connection to MySQL on shared hosting with Python using "MySQLdb.connect" but I get the error:
Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled).
It's possible to make a solution for that.
Upvotes: 1
Views: 357
Answers (1)
niczero
Reputation: 367
Your options are
- Connect to a server >=4.1.1 that has secure_auth enabled, or
- Wait for (or apply) the bug fix http://bugs.mysql.com/bug.php?id=75425 or
- Try one of the workarounds discussed at https://rt.cpan.org/Ticket/Display.html?id=100831
Upvotes: 1
Related Questions
- Unable to establish connection to MySQL server 'Authentication plugin is not supported'
- SSL Connection Error while using MySQL Connector with Python
- Python MYSQL will not connect
- Python MySQL Connector: Can't connect to server with SSL
- error authenaticating sql database from python
- (Python) MySQL database Authentication trouble
- Django/MySQL-python - Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
- mysql-python mac OSX 10.10 disable secure auth
- Is there a way to set secure_auth to false in MySQLdb.connect in Python 2.7.5?
- password error connecting to mysql database with python 3.3.1