Understand the default MariaDB Galera configuration
The grant table defines the initial MariaDB Galera user accounts and their access privileges. The default configuration consists of:
- A privileged account with a username of root. The root user has remote access to the database.
- An anonymous user without remote access to the database server. This user can only connect from the local machine and it is only intended for testing.
- A test database only intended for testing.
MariaDB Galera version
In order to see which MariaDB Galera version your system is running, execute the following command:
$ mysqld --version
MariaDB Galera port
The default port for MariaDB Galera is 3306.
MariaDB Galera configuration file
The MariaDB Galera configuration file is located at /opt/bitnami/mariadb/conf/my.cnf.
The MariaDB Galera official documentation has more details about how to configure the MariaDB Galera database.
Also you can notice that MariaDB Galera uses port 4567, but this is a internal used port for cluster syncronization.
MariaDB Galera log file
The log-error file contains information indicating when MariaDB Galera was started and stopped and also any critical errors that occur while the server is running. If MariaDB Galera notices a table that needs to be automatically checked or repaired, it writes a message to the error log. Find it at /opt/bitnami/mariadb/logs/mysqld.log.