Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. mysql -u root
  2. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
  3.  
  4. sudo mysqld_safe --skip-grant-tables
  5. 2017-05-19T11:54:35.6NZ mysqld_safe Logging to '/usr/local/var/mysql/mac.err'.
  6. 2017-05-19T11:54:35.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
  7. 2017-05-19T11:54:35.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/mac.pid ended
  8.  
  9. mysql.server start --skip-grant-tables
  10.  
  11. mysql -u root -p
  12. mysql> use mysql;
  13. mysql> update user set password=PASSWORD("newpass") where User='ENTER-USER-NAME-HERE';
  14.  
  15. mysqladmin -u root -p oldpassword newpass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement