The Golden Spot

I hope this helps someone who is learning about Linux and web application programming with Python, Django, and Javascript.

Sunday, January 13, 2008

Mysql 5.0 and Django Subversion 6917.

I switched from sqlite3 to mysql 5.0 midway through development, First, I edited settings.py to reflect the database changes. Next, I had to run

$ python manage.py reset auth --noinput

first, in order setup a new admin user by executing

$ python manage.py flush

Finally, I made all the tables in settings.py by running

$ python manage.py syncdb

Labels: , , , ,

Debian Etch AMD64 MySQL(current) root password setup

first view /etc/mysql/debian.cnf

use the user name to login to mysql

$ mysql -u debian-sys-maint -p

Enter the password in the file. To set the root password type:

mysql> USE mysql;

then

mysql> SET PASSWORD FOR root@localhost = PASSWORD('specialSAUCE');

where specialSAUCE is your bullet proof password.

Now continue to use and learn MYSQL.

Labels: , ,