mysqladmin: Access denied for user

[santhanalakshmi]

Change MySQL password for other user :

C:\xampp\mysql\bin>mysqladmin -u paru -psan password 'paru';

mysqladmin:connect to server at 'localhost' failed
error:'Access denied for user 'paru'@localhost' (using password : YES)'


why am i facing this error ? can anyone help me out .

In Mysql am always facing Access denied nu

[Atli]

Hey.

I would have to guess that your user is being... denied access to the server. (You know, like the error states... pretty clearly.)

If this is an XAMPP setup, try logging in as root without a password. It should be set up like that. Then you can change the access and passwords for the other users.

If that doesn't work, you need to find whoever set up the server and ask him to give you access. You need root access to set up user permissions and reset passwords for other users. - And if your root user is password protected, you need that password.

[santhanalakshmi]

hi,

Why Mysqladmin cant change the users password ? Mysqladmin can have all privileges than the root user . why i should login into mysql as root user and then changing the users password.I know that is it possible what u said.

But i dont need that .Now i am trying to change the users password through mysqladmin.

[Atli]

The [url=http://dev.mysql.com/doc/refman/5.1/en/mysqladmin.html#option_mysqladmin_user}mysqladmin[/url] program only changes the password for the user you use to log in with (as far as I can tell, at least). By logging into the mysql client as root, you can change the password for any user.