Install MariaDB on Mac

brew

brew update
brew install mariadb

permission

chmod 777 /usr/local/etc/my.cnf.d

set PATH

cd ~
touch .bash_profile
vi .bash_profile
export PATH=${PATH}:/usr/local/Cellar/mariadb/10.3.15/support-files:/usr/local/Cellar/mariadb/10.3.15/bin
(change 10.3.15 as your version!)

mysql start

brew info mariadb
To have launchd start mariadb now and restart at login:
brew services start mariadb
Or, if you don’t want/need a background service you can just run:
mysql.server start

mysql shell

mysql -u root
show databases;
select table_name from information_schema.tables where table_schema=’mysql’;
use mysql;
exit

mysql workbench

https://dev.mysql.com/downloads/workbench/
Preferences -> SQL Editor and then check the box “Show Metadata and Internal Schemas”

Leave a comment

Your email address will not be published. Required fields are marked *