Guest User

Untitled

a guest
Jun 27th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. mysqladmin -u root password 'asdfghjkl'
  2.  
  3. [client]
  4. password = asdfghjkl
  5.  
  6. ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'
  7.  
  8. update user set password=PASSWORD("") where User='root';
  9.  
  10. sudo service mysql restart
  11.  
  12. grant all privileges on *.* to 'root'@'localhost' identified by '';
  13.  
  14. #> mysqladmin -u root password ''
  15.  
  16. grant usage on *.* to 'root'@'localhost' identified via unix_socket;
  17.  
  18. some_user@box: mysql -u root # denied
  19. root@box: mysql # good
  20. some_user@box: sudo mysql # good, if "some_user" has sudo rights.
Add Comment
Please, Sign In to add comment