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.

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.