Ok, I'm at a loss here. Sorry for my inability to figure out whats going on here but something isn't adding up.
At this point, I'm able to log into mysql with "mysql --user=root mysql -p" then suply the password i defined in the GUI setup. I CANNOT log in with "root@localhost", so i figured that the account was missing (as you had stated). I figure the next step would be is to create "root@localhost", but i receive error 1396 <hy000>. At this point i thought maybe the account is setup but has no password, so i defined a password for "root@localhost", which worked. But after this i cannot go any further.
If i can configure open audit using any user account, then how do i specify that. The directions i was following (which is linked in my original post), state that once the mysql gui config is complete, goto
http://localhost/ to configure the open audit database. But when i do that all i recieve is the original error message (Could not connect: Access denied for user 'root'@'localhost' (using password: YES)).
So how do i config the open audit database using another account? What else am i doing wrong here? I have only followed the steps in the directions i linked above, so if there is a step missing there, please let me know.
Sorry if this is something basic that I'm just not seeing. Thanks for the help.