Improper configuration of mysql database in django

Question

Please, I was trying to install a database into my django environment. So in the settings.py file, I entered the following given that I am used to the MySQL database.. ENGINE: django.db.backends.mysql NAME: /Applications/MAMP/db/ # this is because my 'mysql' is stored in that location on my mac machine USER: herodb #I just gave it this name to be used in django..

Now, I already have databases in my 'mysql' because I have been using it for other projects. so, i dont have to create any databases. Yet when i ran the command : python manage.py syncdb, I get these errors:

Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/core/management/__init__.py", line 453, in execute_from_command_line
    utility.execute()
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/core/management/__init__.py", line 392, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/core/management/__init__.py", line 272, in fetch_command
    klass = load_command_class(app_name, subcommand)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/core/management/__init__.py", line 77, in load_command_class
    module = import_module('%s.management.commands.%s' % (app_name, name))
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/utils/importlib.py", line 35, in import_module
    __import__(name)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/core/management/commands/syncdb.py", line 8, in <module>
    from django.core.management.sql import custom_sql_for_model, emit_post_sync_signal
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/core/management/sql.py", line 9, in <module>
    from django.db import models
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/db/__init__.py", line 40, in <module>
    backend = load_backend(connection.settings_dict['ENGINE'])
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/db/__init__.py", line 34, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/db/utils.py", line 93, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/db/utils.py", line 27, in load_backend
    return import_module('.base', backend_name)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/utils/importlib.py", line 35, in import_module
    __import__(name)
  File "/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/django/db/backends/mysql/base.py", line 17, in <module>
    raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

A careful look at this error, I discovered this : raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e) django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

According to the steps I took earlier, could anyone direct me to where I might have done the imporper configuration? I don't have any sql called MySQLdb. So, how do I fix this error?

You need the name of the database in your configuration, nor the place where the binary or the data is stored. — Matthias
– Matthias, Commented Jul 4, 2013 at 10:03
Give us a copy of your django database config, without any sensetive data, so that we can better judge. — Nafiul Islam
– Nafiul Islam, Commented Jul 4, 2013 at 10:11
@Matthias, my database is in the db directory of the MAMP directory in the Applications directory. Do I need to go any further to get the binary? — helpdesk
– helpdesk, Commented Jul 4, 2013 at 10:19

Daniel Roseman · Accepted Answer · 2013-07-04 10:18:17Z

3

Couple of things:

1) Your DB settings should look like this for MySQL:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'yourdbname',
        'USER': 'yourdbuser',
        'PASSWORD': 'yourdbpassword',
    }
}

2) The traceback tells you you're missing the python mysql library for interfacing with MySQL. Install this using: sudo easy_install MySQL-python or sudo pip install MySQL-python.

edited Jul 4, 2013 at 10:18

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

answered Jul 4, 2013 at 10:09

krak3n

9666 silver badges13 bronze badges

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

3 Comments

helpdesk Over a year ago

I guess my path might be wrong. my 'mysql' folder is in the db folder in the MAMP which is in the Applications directory yet when I run it, i get this : sudo: mysql/: command not found cd /Applications/MAMP/db/ sudo mysql any help on getting this right? I have never had to use mysql from the command line. only on the myphp admin..now am stuck

Daniel Roseman Over a year ago

No-one is asking you to run mysql from the command line at all. You need to run pip or easy-install.

krak3n Over a year ago

Django needs MySQL-python to interface with mysql, all you need to do is install it and Django can then talk to your MySQL database.

Collectives™ on Stack Overflow

Improper configuration of mysql database in django

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related