[rt-users] Trying to fix a broken install of RT2.0.13

[Byron OBrien]

Also, you can start mysqld with the '--skip-grant-tables' option,
which bypasses the privilege protection for all tables, including
(yup, you guessed it)--the user and password tables.  Once it's
up in this mode, you can use mysqladmin to change the password,
or you can invoke mysql and do an 'UPDATE USER...'

Just make sure you do a 'mysqladmin flush-privileges' or a
'FLUSH PRIVILIGES;' from mysql to load the privs when you're done,
otherwise there's nothing to stop *anyone* from doing anything
they want to your database.

Cheers,
Byron

On Mon, 29 Jul 2002, Bruce Campbell wrote:

> On Mon, 29 Jul 2002, RT2 Troubles wrote:
>
> [...]
>
> > If I could afford a support contract I would of bought a product that came
> > with some paid support. I wasn't short-sighted when I installed RT, but I
> > should of written down the mysql password instead of picking something
> > "harmless" that I would soon forget.
>
> Assuming that you have manipulate access to the directories that MySQL is
> using for its database, you can reset the mysql root password by doing:
>
> [...]