19 Apr 2001 donky   » (Apprentice)

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).

Latest blog entries     Older blog entries

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!