Downgrade MariaDB using Brew
After installing MariaDB 10.6+ I started getting errors such as: ERROR 4047 (HY000) at line 10: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE. I needed to go back to the previous version but it was not easier to do so with brew. These are steps I have to take to downgrade it.
brew remove mariadb
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mariadb.plist
rm -rf /usr/local/var/mysql
and then I reinstalled from scratch.
brew install firstname.lastname@example.org