Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. mysqld --skip-grant-tables
  2.  
  3. UPDATE user SET password=PASSWORD('password') WHERE user ='root';
  4.  
  5. mysqladmin shutdown
  6.  
  7. mysql --version команда выдает следующее
  8. mysql Ver 15.1 Distrib 10.1.9-MariaDB, for Win32 (AMD64)
  9.  
  10. mysqld_safe --skip-grant-tables
  11.  
  12. mysql --user=root mysql
  13.  
  14. update user set Password=PASSWORD('new-password') where user='root';
  15. flush privileges;
  16. exit;
  17.  
  18. mysql 5.7
  19.  
  20. mysql --user=root mysql
  21. update user set authentication_string=PASSWORD("new_password") where User='root';
  22. flush privileges;
  23. exit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement