Guest User

Untitled

a guest
Nov 19th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. sudo /etc/init.d/mysql stop
  2. sudo mysqld_safe --skip-grant-tables --skip-networking &
  3.  
  4. mysql -u root
  5.  
  6. USE mysql;
  7. UPDATE user SET password=PASSWORD("new_password") WHERE User='root';
  8. UPDATE user SET plugin="mysql_native_password";
  9. exit
  10.  
  11. sudo /etc/init.d/mysql stop
  12. sudo kill -9 $(pgrep mysql)
  13.  
  14. sudo /etc/init.d/mysql start
  15.  
  16. You will be asked to autheticate using your system admin password.
  17. Done!
Add Comment
Please, Sign In to add comment