Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
  2. mysqld_safe --skip-grant-tables
  3.  
  4. You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
  5. mysql --user=root mysql
  6.  
  7. update user set Password=PASSWORD('new-password') where user='root';
  8. flush privileges;
  9. exit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement