Can't start MySQL to reset root password

Question

I've installed mysql-server on a Linux box and forgot (oops) the root password. Having looked around the internet, the general method is so:

1. Stop MySQL (sudo service mysql stop)
2. Start MySQL in special mode (sudo mysqld_safe --skip-grant-tables)
3. Login to local server and reset password (mysql -u root)

My problem is at number 2. When I run the command, it says some stuff about logging and starting the daemon, then ends with the line

mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

and using sudo service mysql status confirms that MySQL has, indeed stopped.

Why does it stop so suddenly? And (more importantly) how can I get it to keep running so I can reset my password?

Thanks in advance

EDIT Here's the full log of "stuff about loggin and starting the daemon":

$ 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
$ 

EDIT 2 And the output of /var/log/syslog (I've replaced my hostname with <hostname>)

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

Answer 1

OK, it looks like either /var/lib/mysql doesn't exist or the mysql user doesn't have permission to access it. Either way, you have worse problems than having forgotten the root password -- either you don't have a database at all, or something has changed the file permissions or ownership.

Answer 2

This issue might be caused due to several issue. You can find the exact error from "tail /var/log/mysql/error.log". I have added the default fix for these kind of issues. If the below is not working then update us the print from log where we can try to get some info and move further

Kill all the MySQL process using the following command.

ps aux | grep mysql kill pid

Find the path of mysqld daemon using the "which mysqld_safe" command

Start MySQL without grant tables from the mysqld_safe location

/mysqld_safe_available_directory/mysqld_safe --skip-grant-tables &

ex /bin/mysqld_safe

mysql -u root 

Steps to set the new password:

use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit

Answer 3

I faced same problem Aborting come from permission on /var/lib/mysql the folder belong to user mysql, then root has no fully access

solved it by:

$ sudo su - mysql

$ mysqld_safe --skip-grant-tables &

Answer 4

In my case I was manually created the /var/run/mysql folders with root user. Solved issuing

chown -R mysql:mysql /var/run/mysql