Baby Steps with Django - part 2 database setup

25 January 2008

So I introduced this series seven months ago, oops! Oh well, let's get started.

Before we get anywhere, we need to have some kind of database. The main ones we that care about right now are mysql, postgres and sqlite. At this stage in the game, it really makes no difference. I am going to use mysql because I am most familiar with it.

Get the database:

On Ubuntu:

sudo apt-get install mysql-server python-mysqldb

When asked, make up a new mysql admin password.

On Gentoo:

Run each of the following commands, where [version] is the version of mysql and new-password is your new mysql admin password.

emerge mysql mysql-python

emerge --config =dev-db/mysql-[version]

/etc/init.d/mysql start

/usr/bin/mysqladmin -u root -h localhost password 'new-password'

Create a new database and user

mysql -u root -p

Now you are at the mysql prompt that looks like this - mysql>

Enter the following line to create a new database:

CREATE DATABASE djtest;

Enter the following line to create a new database user, feel free to change the last word "password" to something else:

GRANT ALL ON djtest.* TO 'djangouser'@'localhost' IDENTIFIED BY 'password';

Enter the following line to quit mysql:

quit

Database Conclusion

Now we have four values that we can later use for our settings.py file

> DATABASE_ENGINE = 'mysql' DATABASE_NAME = 'djtest' DATABASE_USER = 'djangouser' DATABASE_PASSWORD = 'password'

We have not actually done any Django yet, just the dull system admin tasks that are required. So let's get Django.

Installing Django

On Ubuntu:

sudo apt-get install python-django

On Gentoo:

emerge -vp django

On Gentoo: Make sure you have at least the mysql use flag turned on, you probably also want bash-completion and examples. Then when you are happy emerge django

Discuss this post - Leave a comment

1 bug says...

Where has the world gone to that Zeth started to write things that are so simple they shouldn't be mentioned on a blog that write goodies?

Posted at 10:14 a.m. on January 25, 2008

2 Zeth says...

I know, for people who make websites, knowing how to use mysql is easy, however, it is otherwise not required knowledge.

Posted at 10:38 a.m. on January 25, 2008

3 Zeth says...

SELECT * FROM django_site WHERE id=1;

update django_site set name='commandline.org.uk' WHERE id=1; update django_site set domain='commandline.org.uk' WHERE id=1;

Posted at 7:33 p.m. on May 7, 2008

What do you have to say?

Show Editing Help

About

Hello, my name is Zeth, I'll be your host here.

Command Line Warriors is about taking control of your own technology, it looks at our experiences of computing; especially using GNU/Linux, the Python programming language, the command-line and issues such as techno-ethics, best practices and whatever is cool now. If you take control of your technology then you are a Warrior too!

This site is your site too which means that you can contribute and get involved. You can leave comments using the facility provided. For me, the comments and discussions are by far the best part of the site. So please do have your say!

Latest Discussions

Essex Web Design

September 3, 2010
A lot of contract providers give you free internet usage now, but if you have Pay As You Go, then you are going to be paying heavy prices.
→ Calling time on mobile internet nonsense?

Krasochka

September 2, 2010
Hack again?!
→ Adding more terminals to your function keys

GenryFlorist

September 2, 2010
<b>Cheap flowers delivery around the world!</b> Celebrate summer with our gorgeous flowers. They?re the perfect gift for any summer occasion. From birthdays to anniversaries, we offer beautiful flowers, lush plants, ...
→ Burning an iso to CD on Windows

auto-financing.co.cc

September 2, 2010
auto-financing
→ ReStructuredText tables and doctests

rubaxa

September 1, 2010
FTP = NOT RANDOM software Dominated hands postflop suckout often on all-ins. EX. AK vs. A9 or KQ vs. K6. Both players hit top pair. Bad player goes all in ...
→ Burning an iso to CD on Windows

empodayaddelm

September 1, 2010
Sorry admin - my post is test
→ This Week: Heroes and Monsters

increase synthroid dosage

September 1, 2010
Latest world news: 1 <a target="_blank" class="ext" href=http://www.maktabti.org/profiles/blogs/viagra-cialis-buy-no>buy cheap cialis generic levitra viagra</a> Viagra 2 <a target="_blank" class="ext" href=http://www.maktabti.org/profiles/blogs/buy-viagra-online-at-lowest>rainbowpush discussion board buy viagra</a> Viagra 3 <a target="_blank" class="ext" href=http://www.maktabti.org/profiles/blogs/how-to-get-generic-brand>search viagra ...
→ SFTP in Python: Paramiko

Lacilslaw

September 1, 2010
HYUN JAIMIE enniless and homele JAMILA
→ This Week: Heroes and Monsters

domaserisk

August 31, 2010
who was shaking his head back and forth knowingly Grissom shifted his eyes over at Brass,
→ How I Removed Windows from my Laptop

get ready loan

August 30, 2010
Though, by the you kill the legitimate PC user from visiting the site. Also, think about the dynamic IP's issue.
→ Only the penitent man will pass - on captchas and cotton wool

Packers and movers in pune

August 30, 2010
The topic you disscussed here is very amazing, informative and useful in future...
→ On Comment Spam

serhanters1

August 30, 2010
?? ???????? ??... ??????...... ??. ????????? ??? ??? ???????D ???????? ??. ????? ????? ???? ??? ???=) ?? ?????- http://letitbit.net/download/8746.894a84bc20f38f1661895aeee0/stereokartinki.html ???http://f-zona.ru ? ? ?? ????????????
→ Burning an iso to CD on Windows

strona startowa

August 29, 2010
Thanks For This Post, was added to my bookmarks.
→ Python CGI contact forms

lerexottori

August 29, 2010
?????????????? ??????????
→ Adding more terminals to your function keys

KelpAugmeme

August 29, 2010
aofaapsymp, http://forums.quark.com/members/jennaq.aspx online stock trading broker, rdgofzary
→ PuTTY Series: Adding PuTTY to your system path

Cheeday

August 28, 2010
What flowers do you like?
→ This Week: Heroes and Monsters

magfcvb

August 28, 2010
??????? ?????????????? ?????? - ????? ?????? ?????????????? ??????, ?????????????? ?????? ???????, ?????????????? ?????? crosman, ???? ??????????????? ??????, ?????????????? ?????? ?????? ????????. ???? magazin-oruzhie.ru
→ Include ODF support in the Linux Standard Base?

noni

August 28, 2010
I find myself coming to your blog more and more often to the point where my visits are almost daily now!
→ On Comment Spam

Latenadsfes

August 28, 2010
http://mynewblog.for-breastcancer.com/ http://mynewblog.photoblogcentral.com/ http://ilovezebras.thechicks.org/ http://mynewblog.cyberbardsymposium.com/ http://wewphost.com/ilovezebras/
→ Burning an iso to CD on Windows

LeupoldEst

August 28, 2010
pretty cool stuff here thank you!!!!!!!
→ OOXML Vote Coverage

COMMAND LINE WARRIORS

Taking Control of your Own Technology