Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL
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 Smile | :)
  Permalink  
Comments
sanjiv shah at 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 at 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
Your Filters
Interested
Ignored
     
0 Shai Vashdi 576
1 OriginalGriff 183
2 Tadit Dash 160
3 Sergey Alexandrovich Kryukov 136
4 praveen_07 115
0 Sergey Alexandrovich Kryukov 9,280
1 OriginalGriff 5,473
2 Peter Leow 4,100
3 Maciej Los 3,540
4 Abhinav S 3,333


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