SQL

From Hack Sphere Labs Wiki
Revision as of 15:41, 10 October 2013 by Webdawg (talk | contribs) (Created page with "=SQL Reset Password of User= mysql -u root -p SQL SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass'); or UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='us...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQL Reset Password of User

mysql -u root -p

SQL

SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass');

or

UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='user' AND Host='host';
FLUSH PRIVILEGES;
exit