Guest User

Untitled

a guest
Jan 28th, 2019
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  2.  
  3. $ mysqld_safe --skip-grant-tables
  4. 141219 16:55:20 mysqld_safe Logging to syslog.
  5. 141219 16:55:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  6. 141219 16:55:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  7. $
  8.  
  9. Dec 20 10:20:09 <hostname> mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
  10. Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
  11. Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Warning] Can't create test file /var/lib/mysql/<hostname>.lower-test
  12. Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Warning] Can't create test file /var/lib/mysql/<hostname>.lower-test
  13. Dec 20 10:20:09 <hostname> mysqld: #007/usr/sbin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
  14. Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [ERROR] Aborting
  15. Dec 20 10:20:09 <hostname> mysqld:
  16. Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Note] /usr/sbin/mysqld: Shutdown complete
  17. Dec 20 10:20:09 <hostname> mysqld:
  18. Dec 20 10:20:09 <hostname> mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
  19.  
  20. ps aux | grep mysql kill pid
  21.  
  22. /mysqld_safe_available_directory/mysqld_safe --skip-grant-tables &
  23.  
  24. mysql -u root
  25.  
  26. use mysql;
  27. update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
  28. flush privileges;
  29. quit
  30.  
  31. $ sudo su - mysql
  32.  
  33. $ mysqld_safe --skip-grant-tables &
Add Comment
Please, Sign In to add comment