MySQL 8 environment variables

In this section, we will look at the number of environment variables that are used directly or indirectly for different MySQL programs, changing their behavior with the use of environment variables.

Options provided on the command line take precedence over values specified in the option files and on the environment variables, and similarly values in options take precedence over the environment variables; so in most cases, it is preferred to use an option file instead of environment variables to modify the behavior.

The following is the list of environment variables and descriptions for the variable:

• CXX: The name of your C++ compiler for running CMake
• CC: The name of your C compiler for running CMake
• DBI_USER: The default username for Perl DBI
• DBI_TRACE: Trace options for Perl DBI
• HOME: The default path for the mysql history file is $HOME/.mysql_history
• LD_RUN_PATH: Used to specify the location of libmysqlclient.so.
• LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN: Enables the mysql_clear_password...