Error when starting mariadb - no such process
Looking at the offending line in the startup script, this error indicates:
- the startup script timed out waiting for the server to come up, and
- the server process isn't running.
The command name kill
is a little misleading; it's most commonly used to kill a process, but it can also be used to send an arbitrary signal, or even (with -0
) just to check whether it would be possible to send a signal, which is what's happening here.
To find out why the server didn't come up, you need to check the error log, which on a macOS / Homebrew installation of MySQL or MariaDB is going to be in:
/usr/local/var/mysql/<hostname>.err
If you tail
that file, you should see the reason for the failure, e.g.
2019-11-01 11:29:14 0 [ERROR] Can't start server: Bind on TCP/IP port.
Got error: 48: Address already in use
2019-11-01 11:29:14 0 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
2019-11-01 11:29:14 0 [ERROR] Aborting
(In my case I had another instance of MariaDB running in a Docker container and squatting on port 3306.)
Brew has its own service manager included. Via brew services list
you get all installed services listed. MariaDB should be there.
To start it call brew services start mariadb
.