# MariaDB Environment Variables

MariaDB makes use of numerous environment variables that may be set on your system. Environment variables have the lowest precedence, so any options set on the command line or in an option file will take precedence.

It's usually better not to rely on environment variables, and to rather set the options you need directly, as this makes the system a little more robust and easy to administer.

Here is a list of environment variables used by MariaDB:

| Environment Variable | Description                                                                                                                                                                                                                                                                                                    |
| -------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `CXX`                | Name of the C++ compiler, used for running CMake.                                                                                                                                                                                                                                                              |
| `CC`                 | Name of the C compiler, used for running CMake.                                                                                                                                                                                                                                                                |
| `DBI_USER`           | Perl DBI default username.                                                                                                                                                                                                                                                                                     |
| `DBI_TRACE`          | Perl DBI trace options.                                                                                                                                                                                                                                                                                        |
| `HOME`               | Default directory for the [mysql\_history file](https://mariadb.com/docs/server/clients-and-utilities/mariadb-client/mariadb-command-line-client#the-mysql_history-file).                                                                                                                                      |
| `MYSQL_DEBUG`        | Debug trace options used when debugging.                                                                                                                                                                                                                                                                       |
| `MYSQL_GROUP_SUFFIX` | In addition to the given option groups, also read groups with this suffix.                                                                                                                                                                                                                                     |
| `MYSQL_HISTFILE`     | Path to the [mysql\_history file](https://mariadb.com/docs/server/clients-and-utilities/mariadb-client/mariadb-command-line-client#the-mysql_history-file), overriding the `$HOME/.mysql_history` setting.                                                                                                     |
| `MYSQL_HOME`         | Path to the directory containing the [my.cnf file](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files) used by the server.                                                                                                |
| `MYSQL_HOST`         | Default host name used by the [mariadb command line client](https://mariadb.com/docs/server/clients-and-utilities/mariadb-client).                                                                                                                                                                             |
| `MYSQL_PS1`          | Command prompt for use by the [mariadb command line client](https://mariadb.com/docs/server/clients-and-utilities/mariadb-client).                                                                                                                                                                             |
| `MYSQL_PWD`          | Default password when connecting to `mysqld`. It is strongly recommended to use a more secure method of sending the password to the server.                                                                                                                                                                    |
| `MYSQL_TCP_PORT`     | Default TCP/IP port number.                                                                                                                                                                                                                                                                                    |
| `MYSQL_UNIX_PORT`    | On Unix, default socket file used for localhost connections.                                                                                                                                                                                                                                                   |
| `PATH`               | Path to directories that hold executable programs (such as the [mariadb client](https://mariadb.com/docs/server/clients-and-utilities/mariadb-client), [mariadb-admin](https://mariadb.com/docs/server/clients-and-utilities/administrative-tools/mariadb-admin)), so that these can be run from any location. |
| `TMPDIR`             | Directory where temporary files are created.                                                                                                                                                                                                                                                                   |
| `TZ`                 | Local [time zone](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/internationalization-and-localization/time-zones).                                                                                                                                                     |
| `UMASK`              | Creation mode when creating files. See [Specifying Permissions for Schema (Data) Directories and Tables](https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/specifying-permissions-for-schema-data-directories-and-tables).                                                       |
| `UMASK_DIR`          | Creation mode when creating directories. See [Specifying Permissions for Schema (Data) Directories and Tables](https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/specifying-permissions-for-schema-data-directories-and-tables).                                                 |
| `USER`               | On Windows, up to [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5), the default user name when connecting to the mysqld server. API GetUserName() is used in later versions.                                                |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-environment-variables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.