MySQL Forums
Forum List  »  General

Hash password for mysql above 5.7.6
Posted by: Tobia Bea
Date: August 26, 2015 06:42AM

Hello everyone,
I have an installation script that changes the root password with an hashed one.

My script looks like this:
UPDATE user SET password='*B04156156....' WHERE user='root';

I read that I should change it to "SET PASSWORD" or "ALTER user" instax, infact this script doesn't work anymore with Mysql version 5.7.

My question is: How to update the root password of mysql above version 5.7.6 with an hased string? I don't want to write the clear password to the script.

Thanks you.

Options: ReplyQuote


Subject
Written By
Posted
Hash password for mysql above 5.7.6
August 26, 2015 06:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.