Advertisement
Guest User

Untitled

a guest
Jan 5th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. sudo mysqld_safe --skip-grant-tables
  2.  
  3. sudo mysqld_safe --skip-grant-tables
  4.  
  5. sudo mysql --user=root mysql
  6.  
  7. mysql> update user set Password=PASSWORD('new-password') where user='root';
  8. flush privileges;
  9.  
  10. mysql> update user set authentication_string=PASSWORD('new-password') where user='root';
  11. flush privileges;
  12.  
  13. sudo service mysql stop
  14.  
  15. sudo service mysql start
  16.  
  17. $ sudo killall mysqld
  18.  
  19. sudo mysql_secure_installation
  20.  
  21. Set root password? [Y/n] y (press 'y' to set new password)
  22. New password:
  23. Re-enter new password:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement