MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Posted by: Juan de Dios Palomo
Date: November 23, 2005 03:12PM

Try this

enter as root user and type:
mysql> update user
mysql>set password = old_password ('your password')
mysql> where user = 'your user name';

I had the same problem and it worked.

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


Subject
Written By
Posted
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Digital Surgeon
October 26, 2005 05:03AM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
raul
October 26, 2005 07:23AM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
rion jedi
November 16, 2005 02:11PM
Solution on Win98
David Takle
November 16, 2005 08:10PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
rion jedi
November 16, 2005 02:10PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Maneesh Prakash
November 23, 2005 02:22PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Juan de Dios Palomo
November 23, 2005 03:12PM
ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
amit tomar
March 24, 2008 12:55AM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
no no
December 28, 2008 02:57PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Mohsin Jessa
January 12, 2009 05:46PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Mohsin Jessa
January 13, 2009 01:14AM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Mohsin Jessa
January 15, 2009 09:32PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)
Mohsin Jessa
January 15, 2009 11:22PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
grumman chan
November 25, 2005 07:53PM
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
santosh gire
December 10, 2007 11:50PM


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.