Installing mariaDB on mac

Question

I'm using mac ports to install the mariaDB with the following command:

sudo port install mariadb-server

After the file is installed, I have no idea what's going on next?

I try to find any configuration guidance but I failed, does anybody have some guidance for the next steps after installing from mac ports (like how to start and stop, configure etc)

Answer 1

Install db

sudo -u _mysql /opt/local/lib/mariadb/bin/mysql_install_db

Change root password

/opt/local/lib/mariadb/bin/mysqladmin -u root password 'new-password'

Alternatively you can run:

/opt/local/lib/mariadb/bin/mysql_secure_installation'

You can start the MariaDB daemon with:

cd /opt/local; /opt/local/lib/mariadb/bin/mysqld_safe --datadir='/opt/local/var/db/mariadb'

Answer 2

The configuration will generally end up in /opt/local/ somewhere...

You will probably need to

$ sudo port load mariadb-server

, to start it. And

$ sudo port unload mariadb-server

, to stop it.

This is just the way the macports stuff usually works - I haven't tried it with mariadb specifically...

I hope this helps a little...