Install MariaDB on Mac


brew update
brew install mariadb


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;

mysql workbench
Preferences -> SQL Editor and then check the box “Show Metadata and Internal Schemas”

Categorized as xacdo

By xacdo

Kyungwoo Hyun

Leave a comment

Your email address will not be published.