The Ultimate Guide to High Availability with MariaDB

Comments - Getting started on OS X with Homebrew MariaDB

 
2 years, 11 months ago Daryl Lee
Re: Getting started on OS X with Homebrew MariaDB [Answer]

SOLVED. Thinking back through my effort, I realized I didn't really know that MariaDB was a fork of MySql and not just a wrapper for it. I had actually installed both MySql and MariaDB and there's no telling what damage that did. So I did a full restart of Homebrew (because those were my first two installs) and all is well.

 
2 years, 11 months ago Jan Steinman
Re: Getting started on OS X with Homebrew MariaDB

Yea, that part of the homebrew install seems to be a mess.

They keep changing the damn launch script. It used to be /Library/LaunchDaemons/homebrew.mxcl.mariadb.plist, but now it appears to be /Library/LaunchDaemons/tigerbrew.mistydemeo.mariadb.plist.

They also keep farting with putting it is System space or User space. I think the last time I installed, it put it in /Library/LaunchDaemons. (Ugh. Why put the start-up for a multi-user database in a User's Library?)

The last time I upgraded via homebrew, I think I had to:

  1. cd /Library/LaunchAgents
  2. su
  3. cp tigerbrew.mistydemeo.mariadb.plist /Library/LaunchDaemons
  4. cd /Library/LaunchDaemons
  5. launchctl load tigerbrew.mistydemeo.mariadb.plist
  6. exit

Don't take my word for it! Understand where the new script is, and where you want it to be, and what you have to do to get it to run at system boot — if that is your intention.

I wish the Homebrew would figure this out and remain consistent!

 
2 years, 11 months ago Jan Steinman
Re: Getting started on OS X with Homebrew MariaDB

For some reason, submitting that comment devoured all the tildes I typed.

I believe I found the latest script in TILDE/Library/LaunchAgents. If you're running it multi-user, and want it to start whenever you boot, you need it in /Library/LaunchDaemens, with no leading tilde.

I wish this KnowledgeBase wouldn't fart with what I type in!

(Do character entities work? Testing tilde: ~)

 
2 years, 11 months ago Daryl Lee
Re: Getting started on OS X with Homebrew MariaDB

Followup:

Every ten seconds, I get this added to my /usr/local/var/mysql/tigger.local.err file (tigger is my host name);

210923 10:04:48 mysqld_safe Starting mariadbd daemon with databases from /usr/local/var/mysql
2021-09-23 10:04:48 0 [Note] /usr/local/opt/mariadb/bin/mariadbd (server 10.6.4-MariaDB) starting as process 71685 ...
2021-09-23 10:04:48 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
/usr/local/opt/mariadb/bin/mariadbd: Please consult the Knowledge Base to find out how to run mysqld as root!
2021-09-23 10:04:48 0 [ERROR] Aborting
210923 10:04:48 mysqld_safe mysqld from pid file /usr/local/var/mysql/tigger.local.pid ended
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.