You are not logged in.

#1 2013-04-02 04:43:45

dwieeb
Member
Registered: 2012-07-20
Posts: 5

mysqld doesn't start mysql after root password change

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)
          CGroup: name=systemd:/system/mysqld.service
                  `-control
                    |-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)

Offline

#2 2013-04-02 05:30:26

dwieeb
Member
Registered: 2012-07-20
Posts: 5

Re: mysqld doesn't start mysql after root password change

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.

Offline

Board footer

Powered by FluxBB