'Django & MeMSQL Error when running migrate.py: django.db.utils.OperationalError: (2012, 'Error in server handshake')

I have a Django application with a default MySQL database. I want to move my default Database to MeMSQL.

I set the credentials in settings.py to be:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': MEMSQL_DB,
        'USER': MEMSQL_USER,
        'PASSWORD': MEMSQL_PASSWORD,
        'HOST': MEMSQL_HOST,
        'PORT': '3306'
    }

I try to run manage.py migrate to move all models to the new DB, and get this error:

django.db.utils.OperationalError: (2012, 'Error in server handshake')

If it helps - I tried to test the connection and credentials throughout a workbench (SQL-Pro), and it work successfully. only the manage.py migrate give me this error

mysqldjangomigrationhandshakesinglestore


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions