*grump*

[piranha]

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.

Comments

[vanbeast.livejournal.com]

A little googling turned up this:

safe_mysqld -Sg

-Sg is the same as --skip-grant-tables.

I thought that was interesting. I've never had to recover a password in MySQL before, I always give my users full permissions and a .my.cnf, heh. Also I use postgres now, but that's beside the point.

mysql

[pir-anha.livejournal.com]

that only works if one's already upgraded the database to the version that can do that. which one can only do if one first recovers the root password, should one have forgotten it. :)

Cryptic errors

[nolly.livejournal.com]

perror is my friend. (I agree, it shouldn't be necessary, but it's better than nothing.)

[desert-dragon42.livejournal.com]

Jay offers his sympathies for you having to use mysql.

[huashan.livejournal.com]

OOOooo...that's a very useful bit of information. I'd still trade working on mysql problems any day instead of having to work on coldfusion problems. Good god do I hate that application.