Install mariadb under Mac

1. Enter the official website https://downloads.mariadb.org/mariadb/10.2.6/, download mariadb 10.2.6 stable version (free), select the version when choosing Mac. pkg version, download and double click Install

2. Turn on the Mac terminal

Sudo/usr/local/mariadb/server/bin/mariadb

Enter the administrator password, after connecting to MARIADB, you need to change the root password and create a new user, because the remote tool cannot log in with the root user (the default root password is empty)

3. Change root password and connection mode: (Mysql_native_password: Password login, unix_socket default shell login)

Update Mysql.user set Authentication_string=password (' Password '), plugin= ' Mysql_native_password ', Password=password (' password ') where user= ' root ';

Flush privileges;

4. Start mariadb:

sudo launchctl start com.mariadb.server

5. Turn off the DB:

sudo launchctl stop Com.mariadb.server

Install mariadb under Mac