Hi, I changed the root password using mysql with the --skip-grant-tables option. Now, the daemon (using systemctl on Arch) doesn't start mysql. I can start it manually with "sudo mysqld --user='root'" but the daemon comes up with this error after it hangs for a while:
Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.
'systemctl status mysqld.service' reveals:
mysqld.service - MySQL database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: activating (start-post) (Result: exit-code) since Mon 2013-04-01 23:22:51 CDT; 1min 26s ago
Process: 11100 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
Control: 11101 (mysqld-post)
|-11101 /bin/sh /usr/bin/mysqld-post
`-11797 sleep 1
Right now I have it running by executing "sudo mysqld --user='root'" on command line so my websites are usable.
How can I fix the daemon? I'm stuck and there is nothing about this on google.
Last edited by dwieeb (2013-04-02 04:45:41)
I fixed it. Some of the binary mysql logs (/var/lib/mysql) were owned by root. A quick chown back to mysql:mysql and everything seems to work fine again.