# Django connecting to Mysql on an M1 mac throws NameError **URL:** \ **Category:** Using Django\ **Created:** [January 22, 2021, 9:01am UTC](https://forum.djangoproject.com/t/django-connecting-to-mysql-on-an-m1-mac-throws-nameerror/6236 "2021-01-22T09:01:47Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![vignesk70](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/vignesk70/32/1176_2.png) [@vignesk70](https://forum.djangoproject.com/u/vignesk70)\ **Post date:** [January 22, 2021, 9:01am UTC](https://forum.djangoproject.com/t/django-connecting-to-mysql-on-an-m1-mac-throws-nameerror/6236/1 "2021-01-22T09:01:48Z")
I am having an error when using django to use the Mysql connection to either a local or remote database. Initial error that i had when i tried to install mysqlclient were resolved when in installed using brew mysqlserver and client. I can connect to the local db through command line but when i use the connection through django i get this error. ```auto Exception in thread django-main-thread: Traceback (most recent call last): File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/MySQLdb/ __init__.py", line 18, in from . import _mysql ImportError: dlopen(/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/MySQLdb/_mysql.cpython-39-darwin.so, 2): Symbol not found: _mysql_affected_rows Referenced from: /Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/MySQLdb/_mysql.cpython-39-darwin.so Expected in: flat namespace in /Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/MySQLdb/_mysql.cpython-39-darwin.so During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/threading.py", line 954, in _bootstrap_inner self.run() File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/threading.py", line 892, in run self._target(*self._args, **self._kwargs) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/utils/autoreload.py", line 53, in wrapper fn(*args, **kwargs) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/core/management/commands/runserver.py", line 110, in inner_run autoreload.raise_last_exception() File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/utils/autoreload.py", line 76, in raise_last_exception raise _exception[1] File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/core/management/ __init__.py", line 357, in execute autoreload.check_errors(django.setup)() File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/utils/autoreload.py", line 53, in wrapper fn(*args, **kwargs) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/ __init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/apps/registry.py", line 114, in populate app_config.import_models() File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/apps/config.py", line 211, in import_models self.models_module = import_module(models_module_name) File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/importlib/ __init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "", line 1030, in _gcd_import File "", line 1007, in _find_and_load File "", line 986, in _find_and_load_unlocked File "", line 680, in _load_unlocked File "", line 790, in exec_module File "", line 228, in _call_with_frames_removed File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/contrib/auth/models.py", line 2, in from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/contrib/auth/base_user.py", line 48, in class AbstractBaseUser(models.Model): File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/models/base.py", line 122, in __new__ new_class.add_to_class('_meta', Options(meta, app_label)) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/models/base.py", line 326, in add_to_class value.contribute_to_class(cls, name) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/models/options.py", line 206, in contribute_to_class self.db_table = truncate_name(self.db_table, connection.ops.max_name_length()) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/ __init__.py", line 28, in __getattr__ return getattr(connections[DEFAULT_DB_ALIAS], item) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/utils.py", line 214, in __getitem__ backend = load_backend(db['ENGINE']) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/utils.py", line 111, in load_backend return import_module('%s.base' % backend_name) File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/importlib/ __init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 15, in import MySQLdb as Database File "/Users/vignes/Documents/Development/testmysql/env_test/lib/python3.9/site-packages/MySQLdb/ __init__.py", line 24, in version_info, _mysql.version_info, _mysql. __file__ NameError: name '_mysql' is not defined ``` ---
**Author:** ![vignesk70](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/vignesk70/32/1176_2.png) [@vignesk70](https://forum.djangoproject.com/u/vignesk70)\ **Post date:** [January 30, 2021, 10:17am UTC](https://forum.djangoproject.com/t/django-connecting-to-mysql-on-an-m1-mac-throws-nameerror/6236/2 "2021-01-30T10:17:14Z")
I found a workaround for this problem. [How to use PyMySQL with Django - Adam Johnson](https://adamj.eu/tech/2020/02/04/how-to-use-pymysql-with-django/) used pymysql to connect to the mysqldb. ---
**Author:** ![amukherjee01](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/amukherjee01/32/7255_2.png) [@amukherjee01](https://forum.djangoproject.com/u/amukherjee01)\ **Post date:** [January 30, 2022, 9:59am UTC](https://forum.djangoproject.com/t/django-connecting-to-mysql-on-an-m1-mac-throws-nameerror/6236/3 "2022-01-30T09:59:12Z")
Getting same error above while working with mysql and django. Can any one help ---
**Author:** ![vignesk70](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/vignesk70/32/1176_2.png) [@vignesk70](https://forum.djangoproject.com/u/vignesk70)\ **Post date:** [January 30, 2022, 10:43am UTC](https://forum.djangoproject.com/t/django-connecting-to-mysql-on-an-m1-mac-throws-nameerror/6236/4 "2022-01-30T10:43:07Z")
I installed MAMP and connected to it. after installing the mysqlserver using brew and installing the client binaries. ---
**Author:** ![vignesk70](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/vignesk70/32/1176_2.png) [@vignesk70](https://forum.djangoproject.com/u/vignesk70)\ **Post date:** [January 30, 2022, 10:43am UTC](https://forum.djangoproject.com/t/django-connecting-to-mysql-on-an-m1-mac-throws-nameerror/6236/5 "2022-01-30T10:43:51Z")
By the way you can also try mariadb if you intend to use docker with it.