Starting MariaDB on System Boot

[l008com]

I installed MariaDB on my 10.15 home server and all is well, with one exception. I have to manually start it every time the system boots.

Using the command:
sudo /usr/local/opt/mariadb/bin/mysqld_safe --datadir=/usr/local/var/mysql

If that command looks familiar, it's probably because it is the exact same command the launchd plist included with the package, runs. And when put into the /Library/LaunchDeamons folder and given proper permissions, it should run it as root. Yet it does not. Their launchd script has the keepalive option set. And it does repeatedly try to launch mariadb and it quits or crashes or something, almost instantly, every time.

Yes when I run the command manually, in the terminal.... live is good, it starts right up and everything works perfectly.

Anyone know what's going on with this?

[l008com]

I found a solution! I'm not sure how or why it works, but if you add 'sudo' to the command launchd runs, mariadb is able to start up normally! This doesn't make sense because these launchdeamons are already being run as root, so adding sudo shouldn't DO anything. Yet, it fixes it! Go figure.

...
<key>ProgramArguments</key>
	<array>
		<string>/usr/bin/sudo</string>
		<string>/usr/local/opt/mariadb/bin/mariadbd-safe</string>
		<string>--datadir=/usr/local/var/mysql</string>
	</array>
...