[aklug] New MySQL installation - feeling dumb

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm kind of embarrassed to have to ask this, but here it goes...

I've used MySQL before, but it has been over a year since I set up my
own from scratch. So I installed it on my Debian Lenny i386 machine with
'sudo apt-get install mysql-server". However, when I enter the mysql
shell with the 'mysql' command (as root) I just get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)

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.

I tried using 'mysqladmin' command, as well as mysql_secure_installation
and mysql_setpermission, to try to get a password set or create a
database, but I am eventually asked for a password and am blocked.

Could some jog my memory about what I'm forgetting to do here?

- --
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

iEYEARECAAYFAkoKJ10ACgkQQ5FLNdi0BcVQnwCcCIWPmDgoUv5IXeO0xl6Wj0Jd
x/4AoIiFWXt2mlZ+d/oOeomQsDL82VD0
=baU8
-----END PGP SIGNATURE-----
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Tue May 12 17:50:35 2009