The problem Im facing while trying to connect to database for mysql. I have also given the database settings that i have used.
Traceback (most recent call last): File "manage.py", line 10, in <module> execute_from_command_line(sys.argv) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 453, in execute_from_command_line utility.execute() File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 392, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 272, in fetch_command klass = load_command_class(app_name, subcommand) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 77, in load_command_class module = import_module('%s.management.commands.%s' % (app_name, name)) File "/home/arundhati/Desktop/test/testprac/local/lib/python2.7/site-packages/django/utils/importlib.py", line 35, in import_module __import__(name) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/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 "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/core/management/sql.py", line 9, in <module> from django.db import models File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/db/__init__.py", line 40, in <module> backend = load_backend(connection.settings_dict['ENGINE']) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/db/__init__.py", line 34, in __getattr__ return getattr(connections[DEFAULT_DB_ALIAS], item) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/db/utils.py", line 93, in __getitem__ backend = load_backend(db['ENGINE']) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/db/utils.py", line 27, in load_backend return import_module('.base', backend_name) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/site-packages/django/utils/importlib.py", line 35, in import_module __import__(name) File "/home/ar/Desktop/test/testprac/local/lib/python2.7/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
Databse Settings::
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'. 'NAME': 'ar_test_db', # Or path to database file if using # The following settings are not used with sqlite3: 'USER': '', 'PASSWORD': '', 'HOST': '', # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP. 'PORT': '', # Set to empty string for default. } }
Thanks a lot for the help !!
score:140
It looks like you don't have the python mysql package installed, try:
pip install mysql-python
or if not using a virtual environment (on *nix hosts):
sudo pip install mysql-python
Similar question
- Django AWS Elastic Beanstalk error ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
- django - Error loading MySQLdb module: No module named MySQLdb
- Error loading MySQLdb module with Django on OS X
- Django Error: django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module
- Django 1.4.1 error loading MySQLdb module when attempting 'python manage.py shell'
- Error loading Mysqldb module in Python Django
- django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
- Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'
- Python3 + MySql: Error loading MySQLdb module: No module named 'MySQLdb'
- Error loading MySQLdb module: No module named 'MySQLdb'
score:-3
Maybe you can try the following mode of operation:
sudo python manage.py runserver 0.0.0.0:8000
score:-1
Install (if not found):
pip install mysql.connector
Settings:
'default': {
'ENGINE': 'mysql.connector.django',
'NAME': '...',
'HOST': '...',
'PORT': '3306',
'USER': '...',
'PASSWORD': '...',
}
Some more answer related to the same question
- Docker Alpine: Error loading MySQLdb module
- Error Loading MySQLdb Module and "pip install MySQLdb"
- Django on AWS Elastic Beanstalk - No module named MySQLdb Error
- Google app engine + python (django) deployment error: Error loading MySQLdb module
- Postgres with Django - Improperly configured. Error : ImproperlyConfigured: Error loading psycopg2 module: No module named 'psycopg2'
- ImproperlyConfigured: Error loading MySQLdb module pycharm
- django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named 'MySQLdb'
- Not able to use mysql in google app engine - Error loading MySQLdb module: No module named _mysql. I am using cloudSQL
- Django 500 Internal Server Error - ImproperlyConfigured: Error loading MySQLdb module:
- Error loading MySQLdb module Mountain Lion
score:-1
Try this
apt-get install libmysqlclient-dev
and try again to install mysqlclient:
pip install mysqlclient
score:0
Just to add to other answers, if you're using Django, it is advisable that you install mysql-python BEFORE installing Django.
Related question
- Connecting Django to PostgreSQL - Error loading psycopg2 module despite install
- Deploying mod_wsgi: Error loading MySQLdb module
- Error loading MySQLdb module in MACOSX10.6 (Apache & mod_wsgi)
- Error loading MySQLdb module: python3.5 + Django + mysqlclient OSX
- django import error - No module named core.management
- Django import error - no module named django.conf.urls.defaults
- django.core.exceptions.ImproperlyConfigured: Error loading psycopg module: No module named psycopg
- "No module named simple" error in Django
- VS Code error when importing Django module
- Django unable to find MySQLdb python module
score:0
I wasted a lot of time on this. Turns out that the default database library is not supported for Python 3. You have to use a different one.
score:0
if the error looks like this
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module:
dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/_mysql.so, 2): Library not loaded:
/usr/local/opt/mysql/lib/libmysqlclient.20.dylib
Referenced from: /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/_mysql.so
then try :
pip install python-mysqldb
score:0
Faced similar issue. I tried installing mysql-python
using pip, but it failed due to gcc dependency errors.
The solution that worked for me
conda install mysql-python
Please note that I already had anaconda installed, which didn't had gcc dependency.
score:0
I faced this similar error to when I wanted to use MySQL as the default database.
These error might be as a result of the fact that mysqlclient hasn't been installed.
And this can be installed from the command line using;
pip install mysqlclient
(for recent versions of python)
or pip install mysql-python
(for older versions of python)
In my case, after meeting this requirement, I still had this same error and it was solved as below;
In your django project directory, select venv directory and under these directory,
select the pyvenv.cfg file and click allow on the dialog box which ask you if you want to edit this file. In this file,
include-system-site-packages
is set to false
. So change this line of code to true like this;
include-system-site-packages = true
Everything now works well
score:0
try this, simply using pip: On Windows the recommended command is:
python -m pip install mysqlclient
use it in a virtual environment
score:0
I was stuck in this for a very long and then I realized what's wrong django checks for mysqlclient if it's not installed before django it throws this error so simple solution is
pip uninstall django
pip install mysqlclient
pip install django
score:1
I was having the same problem.The following solved my issue
Run pip install pymysql in your shell
Then, edit the init.py file in your project origin directory(the same as settings.py) and then
add:
import pymysql
pymysql.install_as_MySQLdb()
this should solve the problem.
score:2
With the same error message as Will, it worked for me to install mysql first as the missing file will be added during the installation. So after
brew install mysql
pip install mysql-python
ran without errors.
score:2
This happened with me as well and I believe this has become a common error not only for Django developers but also for Flask as well, so the way I solved this issue was using brew.
brew install mysql
sudo pip install mysql-python
This way every single issue was solved and both frameworks work absolutely fine.
P.S.: For those who use macports (such as myself), this can be an issue as brew works in a different level, my advice is to use brew instead of macports
I hope I could be helpful.
score:2
I think it is the version error.
try installing this in following order:
sudo apt-get install python3-mysqldb
pip3 install mysqlclient
python3 manage.py makemigrations
python3 manage.py migrate
score:3
On Ubuntu it is advised to use the distributions repository.
sudo apt-get install python-mysqldb
score:3
try:
pip install mysqlclient
I recommend to use it in a virtual environment.
score:5
For Ubuntu 16.04 and 18.04 or python 3 versions
sudo apt-get install python3-mysqldb
score:6
Download and install Mysql-python from here for windows environment. http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python.
score:7
If you are using Python version 3.4 or above, you have to install
sudo apt-get install python3-dev libmysqlclient-dev
in your terminal. Then install pip install mysqlclient
on your virtual env or where you installed pip.
score:8
You are missing the python mysqldb
library. Use this command (for Debian/Ubuntu) to install it:
sudo apt-get install python-mysqldb
score:8
It is because it did not find sql connector. try:
pip install mysqlclient
score:8
I've solved this issue in this environment:
$ pyenv --version
pyenv 1.2.9
$ python --version
Python 3.7.2
$ python -m django --version
2.1.7
./settings.py
DATABASES = {
'default': {
'NAME': 'my_db_name',
'ENGINE': 'mysql.connector.django', # 'django.db.backends.mysql'
'USER': '<user>',
'PASSWORD': '<pass>',
'HOST': 'localhost',
'PORT': 3306,
'OPTIONS': {
'autocommit': True,
},
}
}
If you use 'ENGINE': 'mysql.connector.django'
, install driver executing:
$ pip install mysql-connector-python
Successfully installed mysql-connector-python-8.0.15 protobuf-3.7.0 six-1.12.0
Note that $ pip install mysql-python
didn't work for me.
Note that if you use 'ENGINE': 'django.db.backends.mysql'
, you should install driver executing:
$ pip install mysqlclient
Finally execute:
$ python manage.py migrate
If it's all right, python creates all these tables id database:
auth_group
auth_group_permissions
auth_permission
auth_user
auth_user_groups
auth_user_user_permissions
django_admin_log
django_content_type
django_migrations
django_session
score:12
When I set up Django development environment for PyCharm in Mac OS X Mountain Lion with python, mysql, sequel pro application I got error same as owner of this thread. However, my answer for them who is running python-mysqldb under Mac OS Mountain Lion x86_x64 (MySql and Python also should be same architecture) and already tried everything like pip and etc. In order fix this problem do following steps:
- Download MySql for Python from here
- Untar downloaded file. In terminal window do following: tar xvfz downloade.tar.
- cd /to untared directory
- Run sudo python setup.py install
If you get error something like this: "Environment Error: /usr/local/bin/mysql_config not found" then try to add path ass follows: "export PATH=$PATH:/usr/local/mysql/bin". But id did not helped to me and I found another solution. In the end of command execution error output which looks like this:
File "/path_to_file/MySQL-python-1.2.4b4/setup_posix.py", line 25, in mysql_config raise EnvironmentError("%s not found" % (mysql_config.path,))
Open setup_posix.py with vim and go to line 25 (In your case it can be different unless if it is same version).
Line 25 should look like this after your editing unless your mysql have symbolic link like follows '/usr/local/mysql/bin/':
f = popen("%s --%s" % ('/usr/local/mysql/bin/mysql_config', what))
After this I got another error as following:
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: dlopen(/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib Referenced from: /Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/_mysql.so Reason: image not found
Finally I did following in console:
sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib
Currently everything works fine. So I hope it will be helpful for somebody who uses Mac. :)
score:14
My answer is similar to @Ron-E, but I got a few more errors/corrections so I'm putting my steps below for Mac OSX on Mavericks and Python 2.7.6.
Install Python mysql package (if you get a success message, then ignore the below steps)
pip install mysql-python
When I did the above, I got the error "EnvironmentError: mysql_config not found" To fix this, I did the below in terminal:
export PATH=$PATH:/usr/local/mysql/bin
When I reran step 1, I get a new error "error: command 'cc' failed with exit status 1" To fix this, I did the below in terminal:
export CFLAGS=-Qunused-arguments export CPPFLAGS=-Qunused-arguments
I reran step 1 and got the success message 'Successfully installed mysql-python'!
score:40
you have to install python-mysqldb - Python interface to MySQL
Try
sudo apt-get install python-mysqldb
score:46
If you get errors trying to install mysqlclient with pip, you may lack the mysql dev library. Install it by running:
apt-get install libmysqlclient-dev
and try again to install mysqlclient:
pip install mysqlclient
Credit To: stackoverflow.com
More Query from same tag
- Django get base model from parent model
- Add image from static files to Multipart Email in Django
- Saving a model with inlines in Django
- How to automatically hide all slug fields in ModelForm based forms in Django
- Django test data loading best-practices
- django rest framework offline documentation
- How can I disable /account/register on django-registration?
- Mysql query in django view
- Apollo-client returns "400 (Bad Request) Error" on sending mutation to server
- A simple views question for django/jQuery calls
- Django rest framework get user profile data for logged in user
- Heroku not installing psycopg2 from requirements.txt
- my pipenv doesnt create a pipfile and pipfile.lock in any of my projects folders anymore
- How to set a custom field in a Django session model?
- Django Full Text Search Optimization - Postgres