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.

Last modification June 3, 2020