...
Download, install and start MariaDB on your computer. See https://downloads.mariadb.org/.
Info You can install MariaDB standalone or as a galera cluster for high availability. Database clustering is independent of WSO2 product clustering. For more information on setting up a galera cluster, see the MariaDB Galera Cluster documentation.
Info For instructions on installing MariaDB on MAC OS, go to Homebrew.
- Log in to MariaDB as the root user (or any other user with database creation privileges).
mysql -u root -p
Enter the password when prompted.
Info In most systems, there is no default root password. Press the Enter key without typing anything if you have not changed the default root password.
- In the MySQL command prompt, create the database using the following command:
create database regdb;
- Give authorization of the database to the regadmin user as follows:
GRANT ALL ON regdb.* TO regadmin@localhost IDENTIFIED BY "regadmin";
- Once you have finalized the permissions, reload all the privileges by executing the following command:
FLUSH PRIVILEGES;
- Log out from the MySQL prompt by executing the following command:
quit;
...