piranha: red origami crane (Default)
[personal profile] 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.

on 2006-11-18 17:49 (UTC)
Posted by [identity profile] 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.


on 2006-11-18 21:15 (UTC)
ext_481: origami crane (Default)
Posted by [identity profile] 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

on 2006-11-19 01:00 (UTC)
Posted by [identity profile] nolly.livejournal.com
perror is my friend. (I agree, it shouldn't be necessary, but it's better than nothing.)

on 2006-11-19 17:56 (UTC)
Posted by [identity profile] desert-dragon42.livejournal.com
Jay offers his sympathies for you having to use mysql.

on 2006-11-20 17:39 (UTC)
Posted by [identity profile] 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.


piranha: red origami crane (Default)
renaissance poisson

July 2015

   123 4

Most Popular Tags

Expand Cut Tags

No cut tags