NameError: name '_mysql' is not defined Mac Django

Question

I was trying to run python manage.py run server while working with Django after changing my settings.py from this:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

to this:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'storefront',
    }
}

But I was getting this error:

File "/Users/aditi/.local/share/virtualenvs/storefront-4vgosAeV/lib/python3.12/site-packages/django/db/backends/mysql/base.py", line 16, in <module>
    import MySQLdb as Database
  File "/Users/aditi/.local/share/virtualenvs/storefront-4vgosAeV/lib/python3.12/site-packages/MySQLdb/__init__.py", line 24, in <module>
    version_info, _mysql.version_info, _mysql.__file__
                  ^^^^^^
NameError: name '_mysql' is not defined


This is what my __init__.py looks like:

try:
    from MySQLdb.release import version_info
    from . import _mysql

    assert version_info == _mysql.version_info
except Exception:
    raise ImportError(
        "this is MySQLdb version {}, but _mysql is version {!r}\n_mysql: {!r}".format(
            version_info, _mysql.version_info, _mysql.__file__
        )
    )

I downloaded MySQL from this link, the x86 DMG option: https://dev.mysql.com/downloads/mysql/

I have Sonoma 14.3. I am running Python 3.12.7. Please let me know how I can fix this error.

I tried adding this to my .zshrc file:

export PATH="/usr/local/mysql/bin:$PATH"

But it did not work.

UPDATE: I got it to work with PyMySQL, thank you for the help everyone!

Konstantin Svintsov · Accepted Answer · 2025-02-17 07:16:43Z

0

Either "from MySQLdb.release import version_info" or "from . import _mysql" fails, and _mysql is not defined in your except block. It would be better to change your init.py to something like this:

from MySQLdb.release import version_info
from . import _mysql
if version_info != _mysql.version_info:
    raise ImportError(
    "this is MySQLdb version {}, but _mysql is version {!r}\n_mysql: {!r}".format(
        version_info, _mysql.version_info, _mysql.__file__
    )
)

At least, you will see which import fails and probably why.

answered Feb 17 at 7:16

Konstantin Svintsov

1,63711 silver badges25 bronze badges

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

Comments

Rudranarayan Sahu · Accepted Answer · 2025-02-17 07:41:20Z

0

If you use the python package mysqlclient you still need to install the mysql client from Oracle/MySQL. This contains the C-library that the python package uses. To make things more confusing: the python package is in fact written in C for speed increases.

To install this library on MacOS:

% brew install mysql-client

answered Feb 17 at 7:41

Rudranarayan Sahu

1

Collectives™ on Stack Overflow

NameError: name '_mysql' is not defined Mac Django

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related