Archive for the tag 'mysqladmin'

SBDavid

Set a new password using mysqladmin

Set a new password using mysqladmin

shell> mysqladmin password “my new password”

Caution:

Do not use this command used if the server was started with the –skip-grant-tables option. No password change will be applied. This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush operation occurs after you connect. However, you can use mysqladmin flush-privileges to re-enable the grant table and then use a separate mysqladmin password command to change the password.