MariaDB Environment Variables
You are viewing an old version of this article. View
the current version here.
This article is incomplete.
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 |
---|---|
MYSQL_HOME | Path to the directory containing the my.cnf file used by the server. |
MYSQL_HOST | Default host name used by the mysql command line client. |
MYSQL_PS1 | Command prompt for use by the mysql command line 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_TEST_LOGIN_FILE | Name of the .mylogin.cnf login path file. |
MYSQL_UNIX_PORT | On Unix, default socket file used for localhost connections. |
PATH | Path to directories that hold executable programs (such as the mysql client, mysqladmin), so that these can be run from any location. |
TMPDIR | Directory where temporary files are created. |
TZ | Local time zone. |
USER | On Windows, the default user name when connecting to the mysqld server. |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.