Guest User

Untitled

a guest
Mar 2nd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. \!h Change using GRANT, without granting any extra privilages:
  2. GRANT USAGE ON *.* TO 'selina'@'localhost' IDENTIFIED BY 'new_pass'; -- overwritten old password
  3.  
  4. \!h Another way, using SET PASSWORD:
  5. SET PASSWORD FOR 'selina'@'localhost' = PASSWORD('new_pass');
  6.  
  7. \!h Shorter if you're logged in as that user:
  8. SET PASSWORD = PASSWORD('new_pass');
  9.  
  10. \!h Remove a password with SET PASSWORD:
  11. SET PASSWORD FOR 'selina'@'localhost' = '';
Add Comment
Please, Sign In to add comment