[TriLUG] shooting one's self in the foot with MySQL

[Dan Monjar]

OK, so I've had mysql running for quite a while on one of my boxes.  I'm 
using it for Snort with ACID and just recently been playing with FreeRadius 
and mysql.

I got phpMyAdmin working and it kept complaining about mysql not having 
passwords and how I needed to close this gaping security hole. So I 
proceeded to close said hole.... See where I'm going?  I can't get mysql to 
let me access it now.

---------------
[EMAIL PROTECTED] bin]# mysql --user=root mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
---------------
Its not even asking for the password, which I do know.  Before I blow away 
the grant tables and recreate them I'm trying to understand what I did 
wrong and how to fix it.  for instance, why does the error show the user as 
'@localhost'?

--
Dan Monjar
--
TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
TriLUG Organizational FAQ  : http://trilug.org/faq/
TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
TriLUG PGP Keyring         : http://trilug.org/~chrish/trilug.asc