Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL
hi!
I have the error(#1045 - Access denied for user 'root'@'localhost' (using password: NO) )
 
I have read solution on other post that is as follow:
{
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.
I tried reinstalling wampp and then I installed xampp as well but it shows the same problem.
 
Thanks!!
Posted 17-Apr-12 19:44pm
Edited 17-Apr-12 23:57pm
digimanus30.5K
v2
Comments
Sunnykumar08 at 15-May-12 5:25am
   
Are you able to use your MySQL Server on localhost. If yes, the use that password with phpMyAdmin, otherwise did you try re-installing MySQL Server on your localhost?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Just press enter...no need for password for the first time
just press enter and it will go...
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Awesome answer .. it works for me !
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 15 Oct 2012
Copyright © CodeProject, 1999-2014
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