Setting Django up to use MySQL

Question

I want to move away from PHP a little and learn Python  In order to do web development with Python I ll need a framework to help with templating and other things    I have a non-production server that I use to test all of web development stuff on  It is a Debian 7 1 LAMP stack that runs MariaDB instead of the common MySQL-server package   Yesterday I installed Django and created my first project called firstweb  I have not changed any settings yet   Here is my first big piece of confusion  In the tutorial I followed the guy installed Django  started his first project  restarted Apache  and Django just worked from then on  He went to his browser and went to the Django default page with no problems   Me however  I have to cd into my firstweb folder and run  python manage py runserver myip port   And it works  No problem  But I m wondering if it is supposed to work like this  and if this will cause problems down the line   My second question is that I want to set it up so it uses my MySQL database  I go into my settings py under  firstweb firstweb and I see ENGINE and NAME but I m not sure what to put here   And then in the USER  PASSWORD  and HOST areas is this my database and its credentials  If I am using localhost can I just put localhost in the HOST area

User · Answer

As all said above  you can easily install xampp first from https   www apachefriends org download html Then follow the instructions as    Install and run xampp from http   www unixmen com install-xampp-stack-ubuntu-14-04   then start Apache Web Server and MySQL Database from the GUI  You can configure your web server as you want but by default web server is at http   localhost 80 and database at port 3306  and PhpMyadmin at http   localhost phpmyadmin  From here you can see your databases and access them using very friendly GUI  Create any database which you want to use on your Django Project  Edit your settings py file like   DATABASES      default          ENGINE    django db backends mysql        NAME    DB NAME        HOST    127 0 0 1        PORT    3306        USER    root        PASSWORD           Install the following packages in the virtualenv  if you re using django on virtualenv  which is more preferred    sudo apt-get install libmysqlclient-dev  pip install MySQL-python That s it   you have configured Django with MySQL in a very easy way  Now run your Django project   python manage py migrate  python manage py runserver

User · Answer

Andy s answer helps but if you have concern on exposing your database password in your django setting  I suggest to follow django official configuration on mysql connection  https   docs djangoproject com en 1 7 ref databases   Quoted here as      settings py DATABASES          default              ENGINE    django db backends mysql            OPTIONS                  read default file     path to my cnf                          my cnf  client  database   NAME user   USER password   PASSWORD default-character-set   utf8   To replace  HOST    127 0 0 1  in setting  simply add it in my cnf     my cnf  client  database   NAME host   HOST NAME or IP user   USER password   PASSWORD default-character-set   utf8   Another OPTION that is useful  is to set your storage engine for django  you might want it in your setting py    OPTIONS         init command    SET storage engine INNODB

User · Answer

You must create a MySQL database first  Then go to settings py file and edit the  DATABASES  dictionary with your MySQL credentials   DATABASES       default       ENGINE    django db backends mysql     NAME    YOUR DATABASE NAME     USER    YOUR MYSQL USER     PASSWORD    YOUR MYSQL PASS     HOST    localhost       Or an IP that your DB is hosted on   PORT    3306          Here is a complete installation guide for setting up Django to use MySQL on a virtualenv   http   codex themedelta com how-to-install-django-with-mysql-in-a-virtualenv-on-linux

User · Answer

python3 -m pip install mysql-connector pip install mysqlclient  These commands helpful to settingup the mysql db in django without errors

User · Answer

Actually  there are many issues with different environments  python versions  so on  You might also need to install python dev files  so to  brute-force  the installation I would run all of these   sudo apt-get install python-dev python3-dev sudo apt-get install libmysqlclient-dev pip install MySQL-python pip install pymysql pip install mysqlclient   You should be good to go with the accepted answer  And can remove the unnecessary packages if that s important to you

User · Answer

settings py  DATABASES      default          ENGINE    django db backends mysql        NAME    django        USER    root        PASSWORD                 HOST                           PORT    3306        OPTIONS              autocommit   True                then   python manage py migrate   if success will generate theses tables    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   and u will can use mysql   this is a showcase example  test on Django version 1 11 5  Django-pool-showcase

User · Answer

Install mysqlclient   sudo pip3 install mysqlclient  if you get error      Command  python setup py egg info  failed with error code 1 in    tmp pip-install-dbljg4tx mysqlclient    then    1  sudo apt install libmysqlclient-dev python-mysqldb   2  sudo pip3 install mysqlclient      Modify settings py   DATABASES          default              ENGINE    django db backends mysql            NAME    website            USER    root            PASSWORD                HOST    127 0 0 1            PORT    3306            OPTION     init command   SET sql mode  STRICT TRANS TABLE

User · Answer

MySQL support is simple to add  In your DATABASES dictionary  you will have an entry like this   DATABASES          default              ENGINE    django db backends mysql             NAME    DB NAME            USER    DB USER            PASSWORD    DB PASSWORD            HOST    localhost       Or an IP Address that your DB is hosted on          PORT    3306             You also have the option of utilizing MySQL option files  as of Django 1 7  You can accomplish this by setting your DATABASES array like so   DATABASES          default              ENGINE    django db backends mysql            OPTIONS                  read default file     path to my cnf                        You also need to create the  path to my cnf file with similar settings from above   client  database   DB NAME host   localhost user   DB USER password   DB PASSWORD default-character-set   utf8   With this new method of connecting in Django 1 7  it is important to know the order connections are established   1  OPTIONS  2  NAME  USER  PASSWORD  HOST  PORT 3  MySQL option files       In other words  if you set the name of the database in OPTIONS  this will take precedence over NAME  which would override anything in a MySQL option file      If you are just testing your application on your local machine  you can use  python manage py runserver   Adding the ip port argument allows machines other than your own to access your development application  Once you are ready to deploy your application  I recommend taking a look at the chapter on Deploying Django on the djangobook  Mysql default character set is often not utf-8  therefore make sure to create your database using this sql     CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8 bin   If you are using Oracle s MySQL connector your ENGINE line should look like this    ENGINE    mysql connector django       Note that you will first need to install mysql on your OS   brew install mysql  MacOS    Also  the mysql client package has changed for python 3  MySQL-Client works only for python 2   pip3 install mysqlclient

User · Answer

Follow the given steps in order to setup it up to use MySQL database   1  Install MySQL Database Connector        sudo apt-get install libmysqlclient-dev  2  Install the mysqlclient library        pip install mysqlclient  3  Install MySQL server  with the following command        sudo apt-get install mysql-server  4  Create the Database        i  Verify that the MySQL service is running           systemctl status mysql service      ii  Log in with your MySQL credentials using the following command where -u is the flag for declaring your username and -p is the flag that tells MySQL that this user requires a password              mysql -u db user -p       iii  CREATE DATABASE db name       iv  Exit MySQL server  press CTRL   D   5  Add the MySQL Database Connection to your Application       i  Navigate to the settings py file and replace the current DATABASES lines with the following             Database           https   docs djangoproject com en 2 0 ref settings  databases          DATABASES                  default                      ENGINE    django db backends mysql                    OPTIONS                          read default file     etc mysql my cnf                                                               ii  Next  let   s edit the config file so that it has your MySQL credentials  Use vi as sudo to edit the file and add the following information           sudo vi  etc mysql my cnf          database   db name         user   db user         password   db password         default-character-set   utf8  6  Once the file has been edited  we need to restart MySQL for the changes to take effect        systemctl daemon-reload      systemctl restart mysql  7  Test MySQL Connection to Application       python manage py runserver your-server-ip 8000

User · Answer

Run these commands  sudo apt-get install python-dev python3-dev sudo apt-get install libmysqlclient-dev pip install MySQL-python  pip install pymysql pip install mysqlclient   Then configure settings py like  DATABASES          default              ENGINE    django db backends mysql            NAME    django db            HOST    127 0 0 1            PORT    3306            USER    root            PASSWORD    123456             Enjoy mysql connection

User · Answer

If you are using python3 x then Run below command  pip install mysqlclient   Then change setting py like  DATABASES      default          ENGINE    django db backends mysql        NAME    DB         USER    username        PASSWORD    passwd

User · Answer

To the very first please run the below commands to install python dependencies otherwise python runserver command will throw error   sudo apt-get install libmysqlclient-dev sudo pip install MySQL-python   Then configure the settings py file as defined by  Andy and at the last execute    python manage py runserver   Have fun

[python] Setting Django up to use MySQL

Examples related to python

Examples related to mysql

Examples related to django

Examples related to debian