SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass');
newpass
That is equivalent to the following statements:
UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='bob' AND Host='%.loc.gov';FLUSH PRIVILEGES;
No comments:
Post a Comment