(macOs) Error: django.db.utils.OperationalError: (2000, 'Unknown MySQL error')

[VanBap]

Body

Hi All,
I am working on Project using Django on macOS.
I am trying to connect to the MySQL database from remote server, but its giving error when i used macOS. Although it used to work well when i used Linux one.

Here is my part of settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'HOST': os.getenv('MYSQL_DB_HOST'),
        'NAME': os.getenv('MYSQL_DB_NAME'),
        'USER': os.getenv('MYSQL_DB_USER'),
        'PASSWORD': os.getenv('MYSQL_DB_PASSWORD'),
        'PORT': os.getenv('MYSQL_DB_PORT'),
        # 'POOL_OPTIONS': {
        #     'POOL_SIZE': 5,
        #     'MAX_OVERFLOW': 5
        # },
        'TIME_ZONE': 'Asia/Saigon',
        "OPTIONS": {
            # Tell MySQLdb to connect with 'utf8mb4' character set
            "charset": "utf8mb4",
            "init_command": "SET GLOBAL max_connections = 1024",
        },
        'TEST': {
            'NAME': 'test_' + os.getenv('MYSQL_DB_NAME')
        }
    }
}
DJANGO_MYSQL_REWRITE_QUERIES = True

Here is part of my dev-cluster.sh

export MYSQL_DB_HOST=lb-dev
export MYSQL_DB_PORT=16446
export MYSQL_DB_NAME=iva_platform
export MYSQL_DB_WATCHLIST=iva_watchlist
export MYSQL_DB_USER=xxx
export MYSQL_DB_PASSWORD=xxx

When I tried to run the command: python manage.py runserver 0.0.0.0:8000
I got this Error:
django.db.utils.OperationalError: (2000, 'Unknown MySQL error')

I did check the connection to the host (lb-dev) by pinging it or connecting it using DataGrip and it worked completely.
Can anyone help. Has anything changed? Am I doing anything wrong?

Thanks,
Van

Guidelines

• I have read and understood this category's guidelines before making this post.

[VanBap]

I figured out the reason:
MySQL connection compatibility error between macOS and Linux.
When I replaced the Database Engine from settings.py: 'ENGINE': 'django.db.backends.mysql' to 'ENGINE': 'mysql.connector.django',
it run completely well.
Maybe its due to mysqlclient build configuration on macOS (especially when using M1/M2 chip)