MySQL Forums
Forum List  »  Install & Repo

Advanced Search
New Topic

Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)
Posted by: Alfred Delio
Date: August 16, 2007 01:11PM

I get this error and don't know how to fix it.

I used installation wizard to install MySQL. I run it as a service. It starts and stops easily. I just can't connect to the server to from any of the command line programs.

I thought that when MySQL is installed it establishes a root user without a password. Someone from MySQL org told me at change the root user's password. I believe I did that some time ago. I don't exactly remember what I made it anymore, but right after I made the change they suggested I used the password I created and got the same error except that instead of (using PASSWORD: NO) at the end of the message I got (using password: YES)!!! Same problem however!!! But now with their wisdom in telling me to make a password for the root user I have an additional problem--I don't remember the password.

Can I somehow safely remove MySQL from the system and just start over?

Navigate: Previous Message• Next Message
Options: Reply• Quote


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