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.
Leave a Reply
You must be logged in to post a comment.