Skip navigation links

MySQL Forums :: Install & Repo :: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)


Advanced Search

Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)
Posted by: l mh ()
Date: August 13, 2005 10:14PM

Hi everybody..
I'm having a problem while meddling with the Instance Configuration Wizard. I had came across this a couple of times..

<<<<

The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (Using password: NO)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installations is still needed to connect to the server. In this case please select skin now and re-run the Configuration Wizard from the start menu.

>>>>

I had reinstall mysql quite a number of times and it prompts me this error again. Please help..

Thank you very much

regards,
lmh

Options: ReplyQuote


Subject Written By Posted
Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) l mh 08/13/2005 10:14PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) hahahaha268 10/29/2005 06:52AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) mega yasa 04/16/2007 01:59AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Chris Shellenberger 10/17/2007 09:25AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Ivan Atanasov 04/16/2009 12:51AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Marco Polomino 04/29/2009 02:48PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Christina Kuykendall 02/03/2010 05:53PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) cedric Bergé 11/19/2010 01:32AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Abdullah Anshur 03/18/2011 06:19AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Zany Maria 06/28/2011 06:57AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Edward Stephen 04/08/2011 05:30AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Russell Gooday 07/14/2009 10:29AM
My solution re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Murray Matson 04/22/2011 02:04AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Chris Shellenberger 10/17/2007 09:26AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Blake Southwood 12/21/2008 07:28PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Jim Burke 02/09/2009 12:56PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Stephen Leung 07/24/2009 08:27PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Greg Davey 07/25/2009 09:39PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) sankar H 11/11/2009 09:47AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Gilmantas Giesa 11/29/2009 09:30AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Michael Shovman 01/18/2010 07:42AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) THIS WORKED FOR ME Patricio Calderon 02/07/2010 02:14PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) THIS WORKED FOR ME MACHARIA MAINGI 10/20/2010 05:04AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Joe Dickinson 02/27/2011 09:47PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Tharan Ratnam 05/29/2007 07:23AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) gust spam 06/29/2007 07:33AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) yaniv cooper 11/30/2007 09:55PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Ronan LE BOITE 12/05/2008 09:41PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Zahid Hasan 12/18/2009 09:32PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) rajneesh kumar 07/14/2010 12:09PM
Solved it, really simple Raine R 08/23/2010 05:37AM
Re: Solved it, really simple val kire 10/08/2010 02:25PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) mike gieson 01/05/2006 05:01PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) end81 03/20/2006 11:51AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Linda Ruiz 05/15/2006 09:08PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Blind Error 05/15/2006 10:33PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) erik miltonhall 05/13/2007 11:23AM
Connection to database not available zahoor bhat 06/05/2008 12:37PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Francis Regman 02/04/2010 02:02PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Arturo Frias 05/27/2007 10:02PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) annie wang 12/05/2007 03:34PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) sadhana ranasinghe 02/26/2008 09:53PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Thabang Manamela 02/03/2009 04:14AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Bartlomiej Wrzal 01/16/2010 04:34AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Panagiotis Gkountoumis 06/14/2009 09:51AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Farcal Florin 01/14/2010 03:15AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) trinh hieu 03/28/2011 10:19PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) ritchy truyen 03/14/2008 07:14AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Brian Paul 05/19/2009 07:32AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Adam M 05/26/2009 01:03PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Malcolm McKie 05/29/2009 08:07AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Lev Abramovich 06/04/2009 03:56PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) John Franklin 07/15/2009 04:12AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Bushra Fathima 01/12/2011 12:33AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Brian Sullivan 07/26/2009 06:59AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Linda Rankin 12/14/2009 12:07AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Linda Carlos 02/24/2010 09:08AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Linda Carlos 02/24/2010 09:15AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Laxmikant Malgaonkar 03/26/2010 12:24AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Nitin Jain 05/23/2011 11:49PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) sharda kumarsingh 06/16/2009 10:25AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Steve W. 03/22/2008 04:03PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Steven Mettam 09/30/2008 07:38AM
Linda: you are a bloody genius! Neil Buchan 07/02/2009 03:33PM
Linda Ruiz's Method Worked For Me Michael Moreno 06/06/2010 07:44PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) David Heagney 01/24/2011 11:34AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) amila prasanna 10/04/2006 11:51PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Israel Kloss 05/24/2007 02:39PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Lanesa Stubbs 05/26/2007 03:49PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Thomas Bishop 03/26/2008 07:50AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) ken mason 09/26/2009 10:08PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Linda Ruiz 05/16/2006 08:36AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) David Rackauskas 05/19/2006 07:09PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) David Barry 10/28/2006 12:03PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Andrew Loveday 08/14/2008 01:10PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Terry James 10/07/2006 03:00AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) smithygreg 01/07/2007 07:28PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Phil Olson 05/28/2007 05:22AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Mike Eskenazi 04/21/2008 05:31PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Kenneth Lewis 06/05/2008 04:00AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Andreas Magalhães 04/15/2007 04:07PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Peter Bird 04/28/2007 09:19AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Alfred Delio 08/16/2007 01:11PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Steve Mederz 11/20/2009 01:36PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) xavier rollard 08/15/2007 08:16AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Kevin Fitzgerald 03/14/2008 06:57AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Vaibhav Rangare 12/02/2007 10:20PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Jim Burke 02/09/2009 01:36PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) gowrish jsi 01/10/2008 03:27AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) murali krishnan 01/11/2008 05:40AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) puff tissue 03/15/2008 03:50PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Chris Sek 03/28/2008 12:44AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Sofia Loren 06/05/2008 08:44AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Kenneth Lewis 06/04/2008 07:32AM
Solution for: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Ibrahim Assaab 06/07/2008 02:53AM
Re: Solution for: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Hamid Seta 06/09/2008 01:07AM
Re: Solution for: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Thillai Mani 02/17/2010 06:37AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Zaharuddin Ayob 09/28/2008 02:25PM
Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Thierry Granier 12/24/2008 06:39AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Arun N 06/05/2010 12:22PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) juha seppola 03/24/2009 05:42AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) deba rath 01/24/2009 01:25AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Butenkov Dmitry 01/26/2009 06:59AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) bob chiu 03/20/2009 08:14AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Baldeep Hira 07/13/2009 12:57PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES) Eric Slenker 04/16/2009 09:25AM
(Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Vadim Z 04/22/2009 06:24PM
Re: (Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) shan ren 11/29/2009 08:55PM
Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) najeer ahmmad shaik 03/03/2011 05:29AM
Re: (Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) jia dingqiang 01/18/2010 02:12AM
Re: (Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Daniel Crain 01/19/2010 11:50AM
Re: (Solved) Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Robert Terry 02/03/2010 02:07AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Daywan Singh 02/24/2010 04:54AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO): My Solution :) Mark Hughes 04/08/2010 09:45AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Joseph Girona 05/15/2010 04:00PM
Solution to: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) - Or password: YES George Edmonds 05/21/2010 11:48AM
Re: Solution to: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) - Or password: YES roy wilson 10/05/2010 12:21PM
Re: Solution to: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) - Or password: YES Tracy Davids 02/11/2011 06:30AM
Re: Solution to: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) - Or password: YES prasanna ganesh 04/02/2011 01:35AM
Re: Solution to: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) - Or password: YES Ahsanur rahman 08/19/2011 03:58AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) poodesh waran 10/06/2010 01:50AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Animesh Mishra 11/09/2010 04:32AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) ARIEL SEVERINO 02/12/2011 11:13PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Joe Dickinson 02/27/2011 10:56PM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Raj singla 02/28/2011 07:04AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) josh francisco 04/02/2011 08:16AM
Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) cone crusher 05/24/2011 01:15AM
If you're using Windows 7 Romnick Joy Cortez 06/25/2011 07:40PM
Re: If you're using Windows 7 Motohashi Shu 07/04/2011 10:19PM
Re: If you're using Windows 7 santosh mallapuram 08/20/2011 11:18AM
Re: If you're using Windows 7 mike halwits 08/22/2011 01:19AM
If you are using Linux Ilan Tal 10/15/2011 11:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.