Advertisement
Guest User

Untitled

a guest
Oct 15th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. 1. Stop mysql:
  2. $ sudo service mysql stop
  3.  
  4. 2. Step 2: Kill all running mysqld
  5. $ sudo killall -9 mysqld
  6.  
  7. 3. Step 3: Starting mysqld in Safe mode.
  8. $ sudo mysqld_safe --skip-grant-tables --skip-networking &
  9.  
  10. 4. Login as root
  11. $ mysql -u root
  12.  
  13. 5. Update the root user password with these mysql commands
  14. mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost';
  15. mysql> FLUSH PRIVILEGES;
  16. mysql> quit
  17.  
  18. 6. Make sure!: Kill all running mysqld
  19. $ sudo killall -9 mysqld
  20.  
  21. 7. Start mysql normally:
  22. sudo service mysql start
  23.  
  24. Try to login using your new password:
  25. 8. mysql -u root -p
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement