nixCraft

Hi folks,


I followed;
MySQL Change root Password

to change MySQL password.

$ mysqladmin -u root -p oldpassword newpassword
Enter password: (enter Mysqladmin Password here)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'


As root
# mysqladmin -u root -p oldpassword newpassword
Enter password:
mysqladmin: Unknown command: 'MysqladminPassword'


Please help.


B.R.
satimis

Are you sure you know the old password?

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

Hi nixcraft,


YES.


I succeeded changing MySQL root password with following steps;

$ mysql -u root -p mysql> set password = password("newpassword"); mysql> quit Then I can login MySQL with newpassword.


I don't know why;
$ mysqladmin -u root -p oldpassword newpassword

did not work?


B.R.
satimis

There is small typo, here is the correct syntax, if:
OLDpassword is abc
Newpassword must be 123456
Then command should be:
You can omit 'abc' and mysql will prompt for the old password:
HTH

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

Hi nixcraft,


$ mysqladmin -u root -p 'abc' password 123456 It didn't work.

But;
$ mysqladmin -u root -p password 123456 did work. Thanks.


Another question:-
MySQL is running as guest on this Xen box (it can be considered as remote server)

Can I change the root password remotely without ssh-login the server first? (I don't have MySQL running on the host)


B.R.
satimis

Yes.

Only if mysql-networking is configured and root user is allowed to do so... (by default this is disabled)
Replace 192.168.5.100 or remote.server.com with actual remote server.

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

Yes, it has been configured.

I must do it in 2 steps

$ ssh remote.server.com

$ mysqladmin -u root -p password newpassword
Enter password: oldpassword

because I don't have mysqladmin running on the host of the Xen box.


Tried before without success.

$ mysqladmin -h remote.server.com -u root -p newpassword Also tried as root.

satimis

Install mysqladmin command according to your Linux distribution. Also, it can be one command:

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help