Advertisement
NginUS

set mysql password

Jun 15th, 2015
289
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. (Stop mysql service w/ lservices)
  2.  
  3. nano ~/sqlp
  4.  
  5. (Enter the following line substituting desired password)
  6. SET PASSWORD FOR 'root'@'localhost' = PASSWORD('ACTUALPASSWORD');
  7.  
  8. sudo mysqld_safe --init-file=~/sqlp &
  9.  
  10. sudo rm ~/sqlp
  11.  
  12. mysql -u root -p
  13. (Enter password from above file)
  14. (Should get 'mysql>' prompt)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement