#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: omarzaman (---.saudi.net.sa)
Date: December 30, 2012 09:18PM

I forget password of mysql5.5.16.

i unintall it after that i intall wampserver2.2e-php5.3.13-httpd2.2.22-mysql5.5.24-x64.exe.

I did dowload from [downloads.jlbn.net]

after that i follow that instruction.
Step 1: Right click on Wampserver tray icon and select Exit; through Windows Task Manager, make sure no MySQL or wampmysql service is running; then, open folder C:\wamp\bin\mysql\mysql5.x.xx\data\mysql, backup safely to somewhere 3 files listed below and replace them with provided files:

user.frm
user.myd
user.myi

Step 2: In folder C:\wamp\apps\phpmyadminx.xx.x, open file config.inc.php

Find this line:
$cfg['Servers'][$i]['password'] = 'RemoveAnythingHere';

Just close the file if nothing between single quote or remove anything between single quote to become as belows:
$cfg['Servers'][$i]['password'] = '';

Then find this line and make sure the word 'config' is between single quote:
$cfg['Servers'][$i]['auth_type'] = 'config';

Close the file and select Save if prompt

Step 3: Restart wamp to take effect




But it does not work
Help me.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: carakat (---.pools.spcsdns.net)
Date: January 05, 2013 07:28PM

HI Did you ever solve your problem? I am having the same problem and unable to locate any solutions from the posts here. My problem started as soon as I added a password through PHPmyAdmin.. I am only running on my local machine so never set one up but received a message through phpmyadmin that it was recommended so I set one up not thinking it would remove all access for me. ? I guess I will post my problem to the board

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.ppp.as43234.net)
Date: January 06, 2013 02:12PM

Caraket,

Read this it will probably help. Specifically point 3 should address your problem

[forum.wampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.