Aaaaaaargh. Yet again completely lost ability to log into MySQL - forgot password AGAIN!

Heres a good link on how to go about resetting the password.

For the next time..

1. Kill MySQL.
> ps aux | grep mysql // note the PID
> kill -9 [PID_HERE]
2. Start MySQL bypassing grant tables.
> mysqld -Sg
3. Change MySQL password for user root (below prompt is 
MySQL prompt)
> USE mysql;
> UPDATE user
> SET password = password("NEW_PWD_HERE")
> WHERE user = "root";
> flush privileges;
> exit;
4. Repeat step 1 and step 2.
5. Restart mysqld without -Sg flags to restart using grant 
tables (access
control system).

Got the session code mostly working. Main problem is clearing out cookies - can't for the life of me seem to get the browser to immediately delete the cookie. Best I can do is getting it cleared out when the browser closes.

Next comes fleshing out the login process. And the use of MySQL.

Back onto Whelkboard after a short evaluation period of Scoop. Has been decided to make it into something like Scoop - at least to a limited degree. Promised to do some work on it yet again - wonder if I will this time.

Went through the usual process of wondering why Apache was not working. Turned out to be the permissions on the directories - I had recursively set the group and user to the user who was doing the editing. I reset these to "nobody" and it all came right (as compared to munging the all users permissions). I also had to change the config file to reflect the settings on my machine. Also had to change the Apache conf file to reflect the correct document root.

Hopefully this will help me work out what is going wrong the next time.

Started rewrite of whelkboard. Notes:

MySQL:

1. Setting the password for a database user
   
   Assigning a password to the user via

   UPDATE USER
   SET PASSWD = PASSWORD('password')
   WHERE USER='username'

   just didn't seem to assign a properly encrypted password. Eventually discovered (when logged in as the root user)

   SET PASSWORD FOR username = PASSWORD('password');

2. Using MySQLdb
   
   

   db.fetchall()

   returns a tuple containing a tuple for each row. e.g.

   ((1L, 'fudge'))
   

Next step is to build in simple user support and then to hook that into cookies. Would like to run all the python CGI in the same runtime so that I can keep a resident shared object but have no idea how to go about it at this stage.

Why are my spaceships not turning?

Learning Icelandic is very hard. Its funny to find that English is such an easy language to learn comparatively.

Not enough time to write something similar to Scoop in Python or work on my MUD...