MySQL 8 Administrator???s Guide

Setting environment variables

In Command Prompt, we can set environment variables which will affect the runtime execution of the program, or can be set to affect future executions permanently. They can be set up in the startup file or by using the interface provided by the system. A list of environment variables that can affect the MySQL programs are given with details in the MySQL 8 environment variables section.

To specify values for the environment variable, the syntax will be based on the underlying command interpreter. For a Windows system, you can set the user variable using the following syntax:

SET  USER=your_user_name

For a Unix system, it depends on the shell, so you will need to use following syntax if using sh, ksh, zsh, or bash ...