[SOLVED] mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:

124vikas.dange@gmail.com · 11-17-2010, 06:10 AM

Hi forum,

I have installed mysql on my centos 5.2 server. When I try to change the password of mysql root user it give me following error.

my command is : # mysqladmin -u root password mypassword

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:

I don't know what is exact issue.

Thanks
Vikas

cusanno · 11-17-2010, 06:48 AM

Apparently I would say that the old password seems wrong.
Are you sure that you access to the MySQL database with that password?
I do not see any other possible trouble ...

Quote:

Originally Posted by 124vikas.dange@gmail.com

Hi forum,

I have installed mysql on my centos 5.2 server. When I try to change the password of mysql root user it give me following error.

my command is : # mysqladmin -u root password mypassword

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:

I don't know what is exact issue.

Thanks
Vikas

ilikejam · 11-17-2010, 08:37 AM

Hi.

When first installed, the mysql root user doesn't have a password - have you tried logging in with no password?

Dave

Noway2 · 11-18-2010, 11:28 AM

Try mysqladmin -u root -p mypassword, or even mysqladmin -u root -p, which will then prompt you for the password for root. It has been my experience with MySQL that it doesn't like the password in line when using the monitor.

124vikas.dange@gmail.com · 11-19-2010, 01:36 AM

Hi forum,

Thanks for your reply I got the solution for my error.

thanks
Vikas