#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: mriera (---.fibertel.com.ar)
Date: September 27, 2012 09:48PM

At the beginning, I made some testings using WampServer with NO password, using PHP only for webs creations, now when I want to use MySql, so, when I want to use files, I find this issue, and I canĀ“t make changes because of this error.
Thank for your cooperation.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: September 27, 2012 10:01PM

So you have at some time added a password to the root userid, now mysql expects you to use the password.

If you cannot remember the password you set, you will have to save your website code somewhere, uninstall wamp, make sure all the wamp folder and subfiolders are deleted, and then re-install wamp and then put your website coed back into the new wamp fodler.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: stevenmartin99 (Moderator)
Date: September 27, 2012 10:01PM

You added a password at some point

If u want ill reset your password do you don't need to uninstall but it will require Teamviewer

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 09/27/2012 10:02PM by stevenmartin99.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: September 27, 2012 10:04PM

Steve how do you reset the root password then?

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: mriera (---.fibertel.com.ar)
Date: September 27, 2012 10:41PM

At the beginning I put "NO password" on WampServer, so, I never put a password in WampServer..
Now when I want to use MySql I found that WampServer have NO password and MySql has password.
I remember the MySql's password, so, how can I resolve this issue?, where do must I do a change?
Thank you for your responses.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: stevenmartin99 (Moderator)
Date: September 27, 2012 10:46PM

Your confused.

Phpmyadmin connects to mysql.

Phpmyadmin is telling you that's its trying to connect to mysql with no password.

Open c:/wamp/apps/phpmyadmin/config.inc.php

And add a password

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: mriera (---.fibertel.com.ar)
Date: September 28, 2012 03:20PM

THANK YOU!!!!

This question, is only for have a confirmation.
Must I always working with this configuration?, I mean, with the password added in "c:/wamp/apps/phpmyadmin/config.inc.php".

Thank you again.

Options: ReplyQuote
Re: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: September 28, 2012 07:19PM

If yu protect the 'root' userid in mysql with a password, yes you must always use the password to login using phpMyAdmin or the MySQL Console.

You added a password, so you have to use it!

Options: ReplyQuote


Sorry, only registered users may post in this forum.