Access denied for user 'root'@'localhost'
Page 1 of 1

Author:  cdhead13 [ Fri Aug 06, 2010 7:35 am ]
Post subject:  Access denied for user 'root'@'localhost'

Hi guys,
I'm new to open audit and mysql, so I'm hoping to get a little help here. I have been following the guide linked below to get open audit setup. Up until the setup of the open audit database, everything has been going smooth.


Right now, I'm stuck on configuring the database(chapter 5, "setup" section). When i goto "http://localhost:8080" (using port 8080 because the default web page is running another app), i receive the following error "Could not connect: Access denied for user 'root'@'localhost' (using password: YES)".

From what experience i have, this looks like an authentication problem on the mysql side of things, although i can log into mysql using "mysql -u root -p" then entering the password. I've double checked all the steps and i don't see what's wrong at this point. Could i be missing something on iis since im not using the default website? PHP seems to be working properly, based on the output from "http://localhost:8080/php.php".

I'm really not sure where to go from here and my google searches have been less than helpful. Any guidence would be appreciated. Thanks!

Author:  mikeyrb [ Tue Aug 10, 2010 11:15 am ]
Post subject:  Re: Access denied for user 'root'@'localhost'

My guess is that the user 'root'@'localhost' does not exist. Note that mysql can allow separate credentials for the same username depending on the host string used (e.g., inside ip, outside ip). You may need to create the localhost account (or it might have no password).


Or for web based administration of mysql.

Author:  cdhead13 [ Fri Aug 13, 2010 11:54 pm ]
Post subject:  Re: Access denied for user 'root'@'localhost'

But if i am able to log into mysql with "root"@"localhost" using the password i defined, how would the account not be setup or missing a password in mysql? Is there another step im missing?

All I'm looking to accomplish now is to configure the mysql database for open audit. Is it possible to use a different account to setup the database?

Author:  mikeyrb [ Fri Aug 20, 2010 9:10 am ]
Post subject:  Re: Access denied for user 'root'@'localhost'

I think you are logging in as username root, which is different from root at localhost. Access permissions are granular based on IP, and using mysql on the shell is different. You can use whatever username you want.

Author:  cdhead13 [ Fri Aug 27, 2010 1:17 am ]
Post subject:  Re: Access denied for user 'root'@'localhost'

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.

Author:  mikeyrb [ Fri Sep 03, 2010 10:53 am ]
Post subject:  Re: Access denied for user 'root'@'localhost'

The best thing to do is read up on phpmyadmin and follow the MySQL link I gave. It may be that the root@localhost user doesn't have enough permissions.

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group