Add -p to your log in and you will be prompted IE: ./mysql -u user -p You could just add the password to PHPMyAdmin config.inc.php file.. that will allow you to connect via PHPmyadmin.
Dave S. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Monjar Sent: Thursday, October 14, 2004 10:19 AM To: [EMAIL PROTECTED] Subject: [TriLUG] shooting one's self in the foot with MySQL 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 -- 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
