Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- $ mysqld_safe --skip-grant-tables
- 141219 16:55:20 mysqld_safe Logging to syslog.
- 141219 16:55:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- 141219 16:55:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- $
- Dec 20 10:20:09 <hostname> mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
- 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.
- Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Warning] Can't create test file /var/lib/mysql/<hostname>.lower-test
- Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Warning] Can't create test file /var/lib/mysql/<hostname>.lower-test
- Dec 20 10:20:09 <hostname> mysqld: #007/usr/sbin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
- Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [ERROR] Aborting
- Dec 20 10:20:09 <hostname> mysqld:
- Dec 20 10:20:09 <hostname> mysqld: 141220 10:20:09 [Note] /usr/sbin/mysqld: Shutdown complete
- Dec 20 10:20:09 <hostname> mysqld:
- Dec 20 10:20:09 <hostname> mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
- ps aux | grep mysql kill pid
- /mysqld_safe_available_directory/mysqld_safe --skip-grant-tables &
- mysql -u root
- use mysql;
- update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
- flush privileges;
- quit
- $ sudo su - mysql
- $ mysqld_safe --skip-grant-tables &
Add Comment
Please, Sign In to add comment