*grump*

mysql is pissing me off tonight. what's with the cryptic error messages? if you don't have permissions for a file, how about saying "i don't have permission to access that file"? how hard is that?

how to reset the root password, for future reference:

as root, create a text file in /etc/mysql, call it mysql-init. put this in it:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('pickAnewPassword');

chown the file to mysql:mysql.

now run mysqld_safe --init-file=/etc/mysql/mysql-init &

probably a good idea to delete the file after. :) and tomorrow, run the fix for the new grant-tables stuff.

i wonder whether the printhead is dry yet.