Search code examples
phpmacosmacportsmariadb

Installing mariaDB on mac

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)

Solution

  • 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'