Click here to Skip to main content
12,954,001 members (42,555 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
I have this error when I try to open phpmyadmin in localhost page.

Please help . I waiting.
Posted 17-Apr-12 19:31pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

the error indicates that root has a password, but you are not supplying it, hence the (Using password: NO)

Read this [^]for more info.

hope it helps :)
  Permalink  
Comments
sanjiv shah 18-Apr-12 3:00am
   
Actually i am using blank password in config.inc.php. Even then i am getting this error. I have googled for the solution.
I got one as below which is to switch from no password to some password.
The solution is like this:
{
Please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO):

1 : go to your WAMP icon on your PC desktop screen and LEFT CLICK to open the menu, you will see MYSQL folder, CLICK to see MYSQL CONSOLE, open it.

2: now you have DOS screen ( a black screen ) :

A: if you already set a password, type it
B: if you did not do this step yet, write the following red text
B1: use mysql; and click ENTER on your keyboard
3: now write the following red text and click ENTER :

UPDATE mysql.user
->SET Password=PASSWORD("*******")
->WHERE User="root";

don't worry about this sign ( -> ) , because for example when you write ( UPDATE mysql.user ) and you click ENTER on your keyboard, a new line appear with this sign ( -> ), your command will execute when you write this sign ( ; ) at the end of your text and click ENTER.

NOTE: replace the password ******* by your password.

4: now write the following red text and click ENTER :

FLUSH PRIVILEGES;

5: and to exit the black DOS screen now, write exit and click enter.

------------------------- we are finished from MySQL now --------------

6: go to WAMP folder ( open your My Computer, click on C driver, and you will see WAMP folder ), click on APPS folder, and than click on your PHPMYADMIN folder ( e.g my folder called phpmyadmin2.11.6 ) and find the config.inc.php

7: open config.inc.php and find the following orange text:

$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed

and add your password now that you used in step number 3 like that :

[COLOR="rgb(255, 140, 0)"]$cfg['Servers'][$i]['password'] = 'yourpasswordhere'; // MySQL password (only needed[/COLOR]

8: now save this modification, and close config.inc.php

9: go to your web browser and type the following link :

http://localhost/phpmyadmin/

and enjoy, this is what happened with me.
}

But in the Mysql console: i am stuck with the following problem
(Enter password: ) in the command prompt screen.

I have no idea what password it is asking for. can you help me.
I have tried blank, and other possible passwords but it does not work.
So I am unable to follow the instruction of above step no 3.
I tried reinstalling wampp and then I installed xampp as well but it shows the same problem.

i will greatly appreciate any kind of help.
Uday P.Singh 18-Apr-12 8:46am
   
why don't you re-install your WAMP server , with no password
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

please visit below link for solution i have solve my problem by doing this.

http://windowsproblemsandsolutions.blogspot.in/2012/09/1045-access-denied-for-user.html[^]
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,464
CHill60 3,490
Maciej Los 3,123
ppolymorphe 2,020
Jochen Arndt 1,975


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 2 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100