Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Chrisylis (---.tukw.qwest.net)
Date: February 03, 2013 12:42AM

I've been trying to get Wamp Server up and running on windows 7. Several resolved issues later, I'm trying to go to phpmyadmin from the Wamp start page. I'm getting the above message. I've already turned off iis7. I've tested port 80 and it is being used by Apache now. I've followed others' suggestions and edited the last line of the hosts file to read #::1 localhost. Also I've gone into wamp\bin\msql5.5.24\my.ini and have changed 3 instances of port = 3306 to equal 3307. I still get the same message.

My Apache error log has relaying this for the passed few hours:
[Sat Feb 02 15:33:53 2013] [notice] Child 8644: Starting thread to listen on port 80.
[Sat Feb 02 15:34:04 2013] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sat Feb 02 15:34:04 2013] [notice] Child 8644: Exit event signaled. Child process is ending.
[Sat Feb 02 15:34:05 2013] [notice] Child 8644: Released the start mutex
[Sat Feb 02 15:34:06 2013] [notice] Child 8644: All worker threads have exited.
[Sat Feb 02 15:34:06 2013] [notice] Child 8644: Child process is exiting
[Sat Feb 02 15:34:06 2013] [notice] Parent: Child process exited successfully.
[Sat Feb 02 15:34:07 2013] [notice] Apache/2.2.22 (Win64) PHP/5.4.3 configured -- resuming normal operations
[Sat Feb 02 15:34:07 2013] [notice] Server built: May 13 2012 19:41:17
[Sat Feb 02 15:34:07 2013] [notice] Parent: Created child process 7144
[Sat Feb 02 15:34:07 2013] [notice] Child 7144: Child process is running
[Sat Feb 02 15:34:07 2013] [notice] Child 7144: Acquired the start mutex.
[Sat Feb 02 15:34:07 2013] [notice] Child 7144: Starting 64 worker threads.
[Sat Feb 02 15:34:07 2013] [notice] Child 7144: Starting thread to listen on port 80.
[Sat Feb 02 15:34:07 2013] [notice] Child 7144: Starting thread to listen on port 80.


I should add a noob disclaimer: I am a noob.

Options: ReplyQuote
Re: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: February 04, 2013 11:59AM

I would suggest [utting MYSQL back onto port 3306 as changing it solves nothing.

Did you change the password on your mysql 'root' userid?

Options: ReplyQuote
Re: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Chrisylis (---.tukw.qwest.net)
Date: February 04, 2013 06:50PM

It will eventually work if one changes line 10 of the config.inc.php file:
Mine was initially $cfg['Servers'][$i]['port'] = '';<-----that was blank from install.
Had to change it to $cfg['Servers'][$i]['port'] = '3307';<----That solved it.

Options: ReplyQuote
Re: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: RiggsFolly (---.as13285.net)
Date: February 04, 2013 09:16PM

For others viewing this:

Thats not a solution as much as a required amendment to the config having unnecessarily changed the port used by MySQL.

Options: ReplyQuote
Re: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: Chrisylis (---.tukw.qwest.net)
Date: February 04, 2013 10:17PM

To others viewing this:

Apparently in some instances it is. I originally found that resolution by googling questions such as my own and came to find uncountable people in the same boat, some of them having resolved their issue in the same manner (changing to port 3307).

Originally I could not the load localhost index page until I changed to port 3307. In fact, if I change it back to 3306 it is dysfunctional again. I have found 'those' questions/answers useful and affinitive to the issue I was having. The point being -- my Wamp installation now works and I am developing Wordpress and PHP on my laptop.

At some point, some other noob will likely have the same issue I was having and hopefully they will find this and resolve their issue. Not all of us have the same problems, and no one of has the answers to everything.

As far as I am concerned this issue has been resolved. Since there is nothing else useful that can be said on this particular ticket, I see no reason to follow this topic from here on.

Options: ReplyQuote
Re: Error MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Posted by: stevenmartin99 (Moderator)
Date: February 04, 2013 10:22PM

writing 3306 or 3307 along with localhost not loading will destroy any noobs chances of understanding anything.


localhost (apache) uses port 80

mysql using 3306.

you should not change either, with out a good reason.

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.