django project configuration

# configure
sudo apt install python3-dev
sudo apt-get install libmysqlclient-dev
sudo apt-get install mysql-client mysql-server
# for python version > 2
sudo apt install python3-pip
pip install mysqlclient

# solve access denied error
sudo mysql
# check authentication
SELECT user,authentication_string,plugin,host FROM mysql.user;

# alter default root plugin(auth_socket) to (mysql_native_password)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

# check again 
SELECT user,authentication_string,plugin,host FROM mysql.user;
exit;

# now access using:
sudo mysql -u root -p



# setting .env file in development and production
pip install django-environ

# in settings.py file add:

import environ

env = environ.Env()
environ.Env.read_env()

SECRET_KEY = env('SECRET_KEY')

DEBUG = env.bool('DEBUG', default=False)

ALLOWED_HOSTS = ['nimeshpahadi.pythonanywhere.com', '127.0.0.1']

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': env('DATABASE_NAME'),
        'USER': env('DATABASE_USER'),
        'PASSWORD': env('DATABASE_PASSWORD'),
        'HOST': env('DATABASE_HOST'),
        'PORT': env('DATABASE_PORT'),
        'OPTIONS': {
            'sql_mode': 'traditional',
        },
    }
}

# .env file
SECRET_KEY='4848j##%E#D#^^$#jjd'
DEBUG=True
DATABASE_NAME='mydb'
DATABASE_USER='root'
DATABASE_PASSWORD='password'
DATABASE_HOST='localhost'
DATABASE_PORT=''

# make virtualenv in production
mkvirtualenv --python=/usr/bin/python3.6 venv

# debugging
workon myvirtualenv
python -i /var/www/www_my_domain_com_wsgi.py

pip freeze > requirements.txt

# edit /var/www/nimeshpahadi_pythonanywhere_com_wsgi.py file
correct with project name
path = '/home/nimeshpahadi/personal_site'
os.environ['DJANGO_SETTINGS_MODULE'] = 'personal_site.settings'

# setup static files

# upgrade pip and pillow version from venv
python -m pip install --upgrade pip
python -m pip install --upgrade pillow