Geek Answers Handbook

Mysql error 2049 connection using old (pre-4-1-1) authentication with mac

I was migrating mysql from 4.0.24 to 5.6.12 and was actually executed using a python script to migrate data when a fine update for mysql violated my authentication to the old server.

I am using mac os x 10.8.5. previous versions of mysql via brew were 5.5.27, 5.5.28, 5.5.29 and 5.6.12. I had problems with previous use permissions and ended up blowing all these people out (after making a copy of / usr / local). Now all I have is mysql 5.6.13 ... I was able to reinstall 5.6.12 via commit, but version 5.5. * (Files) are no longer available through mysql.com via brew.

So the error I am getting is this:

machine:folder user$ python migrate.py
Traceback (most recent call last):
......
    return DBH( params )
  File "dbh.py", line 32, in __init__
    db=self.params.get('db')
  File "/Volumes/Data/Users/user/.virtualenvs/migrate/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/Volumes/Data/Users/user/.virtualenvs/migrate/lib/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2049, "Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)")

, mysql-python pip; 1.2.3, 1.2.4 ( )

virtualenvwrapper ... pip mysql-python

Mac, , ... , brew mysql - , ; pip mysql-python brew... virtualenv mysql-python. , , , .

, :

? .

+2
1

MySQL 5.6.7 secure_auth, , 5.6.7+ , MySQL pre-4.1. , 4.0.24, MySQL 4.1.

mysql 4.1, --skip-secure-auth. :

mysql -h 127.0.0.1 -u username -p --skip-secure-auth

, secure_auth mysql-python.

+3

More articles:


All Articles