-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
James Zuelow wrote:
> On Tuesday 12 May 2009, Christopher Howard wrote:
>
>> I tried 'mysql -u root' and 'mysql -u root -p', but the results are the
>> same. It asks for my password with the -p switch, but I locked out my
>> root password ages ago and am only using sudo.
>>
>
>> Could some jog my memory about what I'm forgetting to do here?
>
> You've probably found it by now.
>
> Remember the MySQL root user is **NOT** the Linux root user. They are two
> independent accounts. So your Linux root user's password won't work unless
> you've set them to be the same thing.
>
> IIRC when you install mysql on Debian it asks you to set the MySQL root user's
> password. Did you see that debconf question?
(** Christopher hits himself with a big stick **) Yes, I must have
accidentally skipped over that during the install, or put one in quickly
and forgot about it.
Since there wasn't any significant data in the database, I went ahead
and just run an aptitude purge on mysql-server-5.0 and then reinstalled
installed it. Works fine now with the new password.
- --
Christopher Howard
http://indicium.us
http://theologia.indicium.us
I digitally sign /all/ of my e-mails via PGP. If you receive any e-mail
from me without my valid PGP signature, please take additional steps to
verify the authenticity of the message.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkoLQrcACgkQQ5FLNdi0BcW4ggCdEyO54Bod28Nju+7jWMyAykqp
zBMAn0+Y8d0FcMcZ3h0rgyXgaQRge0zm
=mQmt
-----END PGP SIGNATURE-----
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Wed May 13 13:59:34 2009
This archive was generated by hypermail 2.1.8 : Wed May 13 2009 - 13:59:34 AKDT