Welcome! Log In Create A New Profile

mysql:Access denied for user 'root'@'localhost' (using password: NO)

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

77698428Sandra

mysql:Access denied for user 'root'@'localhost' (using password: NO)
September 19, 2012 01:13PM

Registered: 11 years ago
Posts: 43
Rating: 0

Hi,

MySql has been working perfectly fine: 'root' without a password...i've been trying to setup a password for User: 'root' but couldn't.I think something went wrong as i was fiddling...today i cant access PHPMyAdmin sad smiley

Please help!!!
Should i uninstall it and install again? confused smiley

Error: #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Thanks

Reply Quote

Mac

Re: mysql:Access denied for user 'root'@'localhost' (using password: NO)
September 19, 2012 02:01PM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

Probably quicker to uninstall then re-install. There are solutions available on the web (pick one here http://www.apachefriends.org/f/search.php?st=0&sk=t&sd=d&sr=posts&sid=09224b6de70a232d1cafcbefd70061cf&keywords=%231045+-+denied+user+'root'%40'localhost'+(using+password%3A+NO ), but it is much quicker to uninstall re-install

Reply Quote

77698428Sandra

Re: mysql:Access denied for user 'root'@'localhost' (using password: NO)
September 19, 2012 02:26PM

Registered: 11 years ago
Posts: 43
Rating: 0

Thanks Mac, i think its best if i uninstall then re-install...but i need to know what i did wrong so i don't make the same mistake again.should i leave the 'root' password empty?

Reply Quote

Mac

Re: mysql:Access denied for user 'root'@'localhost' (using password: NO)
September 20, 2012 07:15AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

Well, there is not just one reason for such errors, and there are different approaches to fixing it - depending on what really went wrong (same error for different reasons). If this on a real server, one would not want to leave it empty, but that would not be your problem because you will not be responsible for the sever. So all that matters now is to make it work.

Reply Quote

Anonymous User

Re: mysql:Access denied for user 'root'@'localhost' (using password: NO)
September 20, 2012 10:17AM

Rating: 0

I had that problem also, I had to uninstall XAMPP,not just uninstall it but delete the whole folder aswell because some files were still left