Here are my notes on installing Django with MySql. Almost all of this was taken from Zeth's article: Baby Steps with Django - part 2 database setup.
Note: during the installation of mysql-server, you will be prompted for a root password. Use this in the section below.
$ sudo apt-get install python-django $ sudo apt-get install mysql-server $ sudo apt-get install python-mysqldb
Note, use the password you entered when installing MySql
$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE django_db; Query OK, 1 row affected (0.01 sec) mysql> GRANT ALL ON django_db.* TO 'djangouser'@'localhost' IDENTIFIED BY 'mypassword'; Query OK, 0 rows affected (0.03 sec) mysql> quit Bye
$ django-admin startproject mysite
DATABASE_ENGINE = 'mysql' # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'ado_mssql'. DATABASE_NAME = 'django_db' # Or path to database file if using sqlite3. DATABASE_USER = 'djangouser' # Not used with sqlite3. DATABASE_PASSWORD = 'mypassword' # Not used with sqlite3. DATABASE_HOST = '' # Set to empty string for localhost. Not used with sqlite3. DATABASE_PORT = '' # Set to empty string for default. Not used with sqlite3.
$ cd mysite $ python manage.py syncdb Creating table auth_message Creating table auth_group Creating table auth_user Creating table auth_permission Creating table django_content_type Creating table django_session Creating table django_site You just installed Django's auth system, which means you don't have any superusers defined. Would you like to create one now? (yes/no): yes Username (Leave blank to use 'sofeng'): E-mail address: email@example.com Password: Password (again): Superuser created successfully. Installing index for auth.Message model Installing index for auth.Permission model Loading 'initial_data' fixtures... No fixtures found.
$ python manage.py runserver Validating models... 0 errors found. Django version 0.96.1, using settings 'mysite.settings' Development server is running at http://127.0.0.1:8000/ Quit the server with CONTROL-C. [30/Jul/2008 16:37:23] "GET / HTTP/1.1" 404 2053
Point your browser at
you should see the Django It worked! page.
unique!!! 5 stars
absolutely cool ........ wud u mind doing that again for postgresql
Nice! Have been looking through a couple of tutorials, this is by far the best one yet.
very nice man.. pls tell me how can i store the data in mysql from django
Could you tell sth about how to do it on Cent OS system ? It drives me crazy...
Really easy & step by step.
Very good article. I has saved my time. Thanks
excellent!!!!! (y) (y) (y)
thank you soo much
I'm Eliot and this is my notepad for programming topics such as Python, Django, Ubuntu, Emacs, etc... more »