Guest User

Untitled

a guest
Dec 16th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. mysql -u root
  2.  
  3. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  4.  
  5. service mysql stop
  6. service mysql start --skip-grant-tables
  7. mysql
  8.  
  9. UPDATE mysql.user SET password=PASSWORD('whateverpassword')
  10. WHERE user='root' and host='localhost';
  11.  
  12. service mysql restart
  13.  
  14. mysql -uroot -p
  15.  
  16. /var/log/mysqld.log
  17.  
  18. /var/log/mysql/mysqld.log
  19.  
  20. grep 'temporary password' /var/log/mysqld.log
  21.  
  22. mysql -uroot p
Add Comment
Please, Sign In to add comment