thousandlemons/how-to-connect-django-to-remote-mysql.md

## how-to-connect-django-to-remote-mysql.md

      
    Raw
  

              how-to-connect-django-to-remote-mysql.md
            
          
    How to Connect Django to Remote MySQL

==[ONLY for Ubuntu]== Install libmysqlclient-dev
$ sudo apt-get install libmysqlclient-dev
Install mysqlclient.
$ sudo pip install mysqlclient
In settings.py, find the following block:
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    }
}
Replace it with:
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': '[database name]',
        'USER': '[database user with remote access privilege]',
        'PASSWORD': '[password]',
        'HOST': '[server ip address]',
        'PORT': '',
    }
}
On local OS X machine, open ~/.bash_profile, and add the following line into it:
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/
Run django system check.
$ python manage.py check