Changing an existing MySQL password in RHL8

[Gabriel2010]

Hello

Runnin'MySQL 4.x in a RHL8 system.
Had assigned a temporary password to the root account
of MySQL using:

/usr/bin/mysqladmin -u root password passisalive
/usr/bin/mysqladnin - root -h systemname password
passisalive

Now, great, that work, when trying to change the
EXISTING password:

/usr/bin/mysqladmin/ -root passisalive password
passisalive2

This is not working as it reports:
error: 'Access denied for user: 'root@localhost'
(Using password: NO)'

Thanks for your help!



Glad to be here!

 

[sleipnir214]

I'm not sure what the "-root" option is supposed to do. If you are trying to specify a username, it should be "-u root" or "--user=root".

I don't know what you are trying to do with the option "passisalive". If that is the current password, you should either use "-p" (to have the app ask you for the password) or "--password=passisalive" (to specify the current password on the command line).

So the command, assuming that the username is "root", the old password is "passisalive" and the new password is "passisalive2", will be:

mysqladmin -u root --password=passisalive password passisalive2

Issuing "mysqladmin --help" will give you a lot of information.




Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[KarveR]

from a command prompt:

mysql -u root -p
enter current password:
password xxxxxxxx
mysql>use mysql
update user set paswword=password(passisalive2') where user = 'root';

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.