Advertisement
Guest User

Untitled

a guest
May 11th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. # Changing password
  2. Method #1: Use mysqladmin command to change root password
  3. ```
  4. $ mysqladmin -u root -p'oldpassword' password newpass
  5. ```
  6. Method #2: Changing MySQL root user password using the mysql command
  7. ```
  8. $ mysql -u root -p
  9. mysql> use mysql;
  10. mysql> update user set password=PASSWORD("NEWPASSWORD") where User='nixcraft';
  11. ysql> flush privileges;
  12. mysql> quit
  13. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement