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”
