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 to reflect the database changes. Next, I had to run

$ python reset auth --noinput

first, in order setup a new admin user by executing

$ python flush

Finally, I made all the tables in by running

$ python 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;


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

where specialSAUCE is your bullet proof password.

Now continue to use and learn MYSQL.

Labels: , ,