#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: y2ck (---.36-176-173.mc.videotron.ca)
Date: August 14, 2012 04:30AM

I've tried some of the suggested adjustments from this forum, but I still can't get access.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: August 14, 2012 10:49AM

This suggests that you have changed the password for the 'root' user in the mysql database but have not changed the root password in the phpMyAdmin config file.

If this is what you have done try the following:

Look in c:\wamp\apps\phpmyadminx.y.z\config.inc.php

Change these lines as follows:

$cfg['Servers'][$i]['password'] = 'YourPassword';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: y2ck (---.36-176-173.mc.videotron.ca)
Date: August 15, 2012 06:44AM

I still get the same error message, but now (using password YES)

this is what I have

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '********';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/* End of servers configuration */

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: August 15, 2012 11:43AM

1. Are you sure you have used the correct password.
2. Did you change the password using myPhpAdmin?

It might be simpler to Uninstall and then re-install and then read through this.

[forum.wampserver.com]

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: y2ck (---.36-176-173.mc.videotron.ca)
Date: August 16, 2012 05:15AM

I'm pretty sure I changed the password, I went under privileges and changed it under root.
Ever since then I keep getting error msgs.
I even tried uninstalling it, but nothing works. I feel very mixed up with all the changes i've tried to effect.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: August 16, 2012 11:08AM

Ok,

Try this.

Uninstall WAMP using the proper uninstall in Control Panel -> Programs and Features

Then make sure the c:\wamp folder and everything in it is deleted. Wamp uninstall keeps things you may have changed so the delete of the folder and all its sub folders is important in your case.

Then reinstall.

This should start you off with a completely new WAMP environment.

Then work through the doc I linked to earlier.

Options: ReplyQuote


Sorry, only registered users may post in this forum.