Advertisement
Guest User

Untitled

a guest
Oct 4th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. 2015-10-25T02:10:54.549219Z 1 [Note] A temporary password is generated for root@localhost: R>gFySuiu23U
  2.  
  3. If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.
  4.  
  5. Unable to connect to host 127.0.0.1 because access was denied.
  6.  
  7. Double-check your username and password and ensure that access from your current location is permitted.
  8.  
  9. MySQL said: Access denied for user 'root'@'localhost' (using password: NO)
  10.  
  11. Unable to connect to host 127.0.0.1, or the request timed out.
  12.  
  13. Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
  14.  
  15. MySQL said: Your password has expired. To log in you must change it using a client that supports expired passwords.
  16.  
  17. mysql -u root -h 127.0.0.1 -p
  18. Enter password: (enter the random password here)
  19.  
  20. UPDATE user SET authentication_string = PASSWORD('YourNewPassword'), password_expired = 'N' WHERE User = 'root';
  21.  
  22. cd /usr/local/mysql/bin
  23. mysql -u root -p --connect-expired-password
  24.  
  25. SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mySuperSecretPassword');
  26.  
  27. mysql: unknown option '--connect-expired-password'
  28.  
  29. /usr/local/mysql/bin/mysql -u root -p --connect-expired-password
  30.  
  31. cd /usr/local/mysql/bin
  32. ./mysql -u root -p --connect-expired-password
  33.  
  34. SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourNewPassword');
  35.  
  36. cd /usr/local/mysql/bin
  37.  
  38. ./mysql -u root -p --connect-expired-password
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement